Oracle Apps Technical Stuff
Tuesday, July 20, 2021
FA:OM:SQL To List EFF Segments and attribute Columns mapping for Specific Context
›
SELECT DISTINCT fdcb.context_code , fdcb.context_identifier , fdcb.enabled_flag , fdsb.segment_co...
Wednesday, July 14, 2021
FA:Query - List of Assigned Roles For a Given User
›
SELECT ase_user_vl.user_id user_id , ase_user_vl.user_login user_login , ase_user_vl.user_display_name user_display_name , as...
Friday, July 9, 2021
FA:SQL:Manage Data Access for Users
›
SELECT username , role , security_context , security_context_value FROM ( SELECT pu.username , prd.role_name...
Tuesday, July 6, 2021
FA:RCV:SQL to get RMA Receipts Details in Oracle Fusion
›
REM RMA Receipts Details SELECT DHA.SOURCE_ORDER_NUMBER , HDR_LKP.MEANING ORDER_TYPE , DFLA.SOURCE_LINE_NUMBER , LINE_LKP.ME...
Thursday, July 1, 2021
FA:MFG: SQL's to extract Details on Manage Work Area/Resources/Work Centers/Standard Operations
›
--Manage work Area SELECT iop.organization_code , wwav.work_area_name , wwav.work_area_code , wwav.work_area_d...
‹
›
Home
View web version