Friday, June 28, 2024

Query to know form attached to which responsibility

Query to know form attached to which responsibility


SELECT
        d.responsibility_name,
        bb.FORM_NAME fmx_name,
        c.FUNCTION_NAME function_name
FROM
        fnd_menu_entries a     ,
        fnd_menu_entries_vl b  ,
        fnd_form_functions c   ,
        fnd_responsibility_vl d,
        fnd_form bb
WHERE
        a.menu_id       = b.menu_id
AND     a.function_id   = b.function_id
AND     b.function_id   = c.function_id
AND     a.menu_id       = d.menu_id
and     bb.FORM_ID      =c.FORM_ID
AND     c.function_name = :function_name
and     bb.FORM_NAME=:fmx_name

No comments:

Post a Comment

EBS : Package Development Process

====================== Package Specification ================================== CREATE OR REPLACE PACKAGE xx_emp_package IS     PROCEDURE lo...