SELECT frv.responsibility_name, fpo.profile_option_name, fpot.user_profile_option_name, fpov.profile_option_value FROM fnd_profile_options_tl fpot, fnd_profile_options fpo, fnd_profile_option_values fpov, FND_RESPONSIBILITY_VL frv WHERE fpot.profile_option_name = fpo.profile_option_name AND fpo.profile_option_id = fpov.profile_option_id…
Read MoreSELECT FRV.responsibility_name, fm.menu_name, FMEV.ENTRY_SEQUENCE, FMEV.PROMPT, FMEV.DESCRIPTION, SUB_MENU_FMEV.USER_MENU_NAME SUB_MENU_NAME, SUB_MENU_FMEV.DESCRIPTION SUB_MENU_DESCRIPTION, FFFT.USER_FUNCTION_NAME, FMEV.GRANT_FLAG FROM apps.FND_MENU_ENTRIES_VL FMEV, apps.FND_MENUS_TL SUB_MENU_FMEV, APPS.FND_FORM_FUNCTIONS_TL FFFT, …
Read MoreORA-30006 and ORA-00054 errors raised when update operation is performed against a record, that has been locked by the user or some session FOR UPDATE. To fix this, before performing the update, check…
Read MoreManual AP Invoice Creation and Cancellation with GST: Please find the below steps for Manual AP Invoice Creation and Cancellation with GST Responsibility: India Local Payables Navigation: Invoices > Entry…
Read MoreBill of Entry Process after GST Implementation: Item Needs to be assigned as GST & GST customs and recoverable tax to be given as Y Item Definition -> Define Item…
Read MoreCREATE OR REPLACE PACKAGE XX_SO_PROG_PKG as –*************************************************************************************************** — — All rights reserved –*************************************************************************************************** — — Package Name …
Read MoreCREATE OR REPLACE PACKAGE XX_BSA_LOAD_PKG IS –================= — Global Variables –================= gn_request_id NUMBER := apps.fnd_global.conc_request_id; gn_prog_appl_id NUMBER := apps.fnd_global.prog_appl_id;…
Read MoreDECLARE l_project_id_PREM PA_PROJECT_PARTIES.PROJECT_ID%TYPE :=NULL; l_project_role VARCHAR2(240) :=NULL; l_resource_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE :=NULL; l_start_date_active DATE :=NULL; l_end_date_active …
Read MoreDECLARE l_return_status VARCHAR(10); l_msg_count VARCHAR(240); l_MSG_DATA …
Read MoreDECLARE l_project_id_PREM PA_PROJECT_PARTIES.PROJECT_ID%TYPE :=NULL; l_project_role VARCHAR2(240) :=NULL; l_resource_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE :=NULL; l_start_date_active DATE :=NULL; l_end_date_active …
Read More