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 899: /If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all /

895: )
896: )
897: ); 7531681 */
898:
899: /*If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all */
900: /*Exists clause before fixing bug 3019361 is as follows
901: and exists (select null
902: from pa_bc_commitments_all bc,
903: pa_cost_distribution_lines_all cdl1

Line 902: from pa_bc_commitments_all bc,

898:
899: /*If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all */
900: /*Exists clause before fixing bug 3019361 is as follows
901: and exists (select null
902: from pa_bc_commitments_all bc,
903: pa_cost_distribution_lines_all cdl1
904: where cdl1.burden_sum_source_run_id = ei.burden_sum_dest_run_id
905: and bc.document_header_id = to_number(cdl1.system_reference2)
906: and bc.document_distribution_id = to_number(cdl1.system_reference3)))); --'ER'

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

1093: )
1094: )
1095: ); 7531681 */
1096:
1097: /*If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all */
1098: /*Exists clause before fixing bug 3019361 is as follows
1099: and exists (select null
1100: from pa_bc_commitments_all bc,
1101: pa_cost_distribution_lines_all cdl1

Line 1100: from pa_bc_commitments_all bc,

1096:
1097: /*If above exists clause performs badly, alternative 2 is to replace join to ei with pa_bc_commitments_all */
1098: /*Exists clause before fixing bug 3019361 is as follows
1099: and exists (select null
1100: from pa_bc_commitments_all bc,
1101: pa_cost_distribution_lines_all cdl1
1102: where cdl1.burden_sum_source_run_id = ei.burden_sum_dest_run_id
1103: and bc.document_header_id = to_number(cdl1.system_reference2)
1104: and bc.document_distribution_id = to_number(cdl1.system_reference3)))); --'ER'

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

1369: l_PktReference3Tab PA_PLSQL_DATATYPES.Char80TabTyp;
1370: -- R12 Funds Management Uptake
1371: l_BurMethodcodeTab PA_PLSQL_DATATYPES.Char30TabTyp;
1372:
1373: --Cursor to select all commitment transactions from pa_bc_commitments_all
1374: --for a given project_id and the current baselined budget version id. The
1375: --check for later is because there might be commitments with old budget
1376: --version id which were funds checked during the delta time.
1377: --Removing the current baselined budget check as now we are handling that

Line 1416: from pa_bc_commitments_all bc,

1412: ,bc.reference2
1413: ,bc.reference3
1414: -- R12 Funds Management Uptake
1415: ,bc.burden_method_code
1416: from pa_bc_commitments_all bc,
1417: pa_tasks pt
1418: --,pa_budget_versions pbv,
1419: --pa_budget_types pbt
1420: where bc.project_id = p_project_id