Tuesday, October 22, 2013

This script will accept the menu name as parameter and will list all functions that can be accessed under that menu.



SELECT DISTINCT
    fmep.menu_id,
    DECODE(fmep.function_id,NULL, DECODE(fmec.function_id, NULL,DECODE(fmec1.function_id,NULL,
    'No Func',fmec1.function_id ),
    fmec.function_id),
    fmep.function_id) funcID,
    fff.user_function_name,
    fff.description
FROM
    fnd_form_functions_tl fff,
    fnd_menu_entries fmec1,
    fnd_menu_entries fmec,
    fnd_menu_entries fmep
WHERE fmep.menu_id =
                        (
                        SELECT menu_id
                        FROM fnd_menus
                        WHERE menu_name='INV_NAVIGATE'Â --Change the menu according to your requirement
                        AND ROWNUM=1
                        )
    AND fmep.sub_menu_id = fmec .menu_id(+)
    AND fmec.sub_menu_id = fmec1 .menu_id (+)
    AND fff.function_id = DECODE (fmep.function_id,NULL,DECODE(fmec.function_id, NULL,DECODE(fmec1.function_id,NULL,-999,fmec1.function_id),fmec.function_id),fmep.function_id)
ORDER BY DECODE(fmep .function_id,NULL, DECODE(fmec.function_id, NULL,DECODE(fmec1.function_id,NULL, 'No Func',fmec1.function_id ),fmec.function_id),fmep.function_id)

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect