Menu and Functions Related Scripts

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)