Tuesday 29 December 2015

SQL Script to know the form name (.fmb) and funtion name in oracle apps 11i

--SQL Script to know the form name (.fmb) and funtion name in oracle apps 11i

SELECT fff.function_name,
           ff.form_name,
           ffft.user_function_name,
           fff.function_id,
           ff.form_id,
           fff.application_id
FROM   fnd_form ff,
       fnd_form_functions fff,
       fnd_form_functions_tl ffft
WHERE  ff.form_id = fff.form_id
AND    fff.function_id = ffft.function_id
AND    ffft.language = 'US'
--AND fff.application_id = 20003   --Inventory Module
and ff.form_name like 'XXTABLE_NAME%'  -- Form Name .fmb
ORDER BY ffft.user_function_name;

Script to update salespersons customer site wise in oracle apps R12

SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'DEENA VISION%'; SELECT * FROM HZ_CUST_ACCOUNTS_ALL WHERE PARTY_ID =94043 ; SE...