eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BGT_BASELINE_PKG dependencies on PA_BC_COMMITMENTS_ALL

Line 817: /If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all /

813: )
814: )
815: );
816:
817: /*If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all */
818: /*Exists clause before fixing bug 3019361 is as follows
819: and exists (select null
820: from pa_bc_commitments_all bc,
821: pa_cost_distribution_lines_all cdl1

Line 820: from pa_bc_commitments_all bc,

816:
817: /*If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all */
818: /*Exists clause before fixing bug 3019361 is as follows
819: and exists (select null
820: from pa_bc_commitments_all bc,
821: pa_cost_distribution_lines_all cdl1
822: where cdl1.burden_sum_source_run_id = ei.burden_sum_dest_run_id
823: and bc.document_header_id = to_number(cdl1.system_reference2)
824: and bc.document_distribution_id = to_number(cdl1.system_reference3)))); --'ER'

Line 931: /If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all /

927: )
928: )
929: );
930:
931: /*If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all */
932: /*Exists clause before fixing bug 3019361 is as follows
933: and exists (select null
934: from pa_bc_commitments_all bc,
935: pa_cost_distribution_lines_all cdl1

Line 934: from pa_bc_commitments_all bc,

930:
931: /*If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all */
932: /*Exists clause before fixing bug 3019361 is as follows
933: and exists (select null
934: from pa_bc_commitments_all bc,
935: pa_cost_distribution_lines_all cdl1
936: where cdl1.burden_sum_source_run_id = ei.burden_sum_dest_run_id
937: and bc.document_header_id = to_number(cdl1.system_reference2)
938: and bc.document_distribution_id = to_number(cdl1.system_reference3)))); --'ER'

Line 1207: --Cursor to select all commitment transactions from pa_bc_commitments_all

1203: l_PktReference3Tab PA_PLSQL_DATATYPES.Char80TabTyp;
1204: -- R12 Funds Management Uptake
1205: l_BurMethodcodeTab PA_PLSQL_DATATYPES.Char30TabTyp;
1206:
1207: --Cursor to select all commitment transactions from pa_bc_commitments_all
1208: --for a given project_id and the current baselined budget version id. The
1209: --check for later is because there might be commitments with old budget
1210: --version id which were funds checked during the delta time.
1211: --Removing the current baselined budget check as now we are handling that

Line 1250: from pa_bc_commitments_all bc,

1246: ,bc.reference2
1247: ,bc.reference3
1248: -- R12 Funds Management Uptake
1249: ,bc.burden_method_code
1250: from pa_bc_commitments_all bc,
1251: pa_tasks pt
1252: --,pa_budget_versions pbv,
1253: --pa_budget_types pbt
1254: where bc.project_id = p_project_id