SELECT fa.application_short_name, frg.request_group_name, fe.execution_file_name, fe.executable_name FROM fnd_request_group_units frgu, fnd_concurrent_programs fcp, fnd_request_groups frg, fnd_executables fe, fnd_application fa WHERE frgu.request_unit_id = fcp.concurrent_program_id AND frgu.request_group_id = frg.request_group_id AND fe.executable_id = fcp.executable_id AND FRG.application_id = fa.application_id AND fe.executable_name = ‘XX_PC_PURCHASE’;
In the following Query you can get Operating Unit Name based on the Operating Unit ID.select Business_group_id, Organization_id, name,date_from,date_to, legal_entity_id, set_of_books_id from hr_operating_units where organization_id = ‘your Operating Unit ID’;
With the following query, you can get the concurrent program name based on the Concurrent request IDSelect program from FND_CONC_REQ_SUMMARY_Vwhere request_id = ‘Your request ID’;
FORALL concept help us reducing the Iterations between PL/SQL Block and SQL Engine.Note:- When ever, we excute any DML (INSERT or UPDATE or DELETE) Operations in the PL/SQL block then, It will move from PL/SQL Block to SQL Engine to excute the DML Operation in SQL Engine.If we have some LOOP and it is looping […]
Bulk Collect concept help us reducing the Iterations between SQL Engine and PL/SQL Block.Note:- When ever, we excute any DML (INSERT or UPDATE or DELETE) Operations in the PL/SQL block then It will move from PL/SQL Block to SQL Engine to excute the DML Operation in SQL Engine. And if we have some SELECT statement […]
Recent Comments