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_EXPENDITURE_ITEMS_ALL

Line 756: from pa_expenditure_items_all ei,

752: ,cdl.expenditure_item_id
753: ,cdl.line_num
754: --PA.M selecting -99 for parent bc pkt for CWK BTC EIs
755: ,decode(ei.system_linkage_function, 'BTC', decode(nvl(ei.po_line_id,-99), -99, null, -99), null)
756: from pa_expenditure_items_all ei,
757: -- pa_expenditures_all exp, -- 7531681
758: pa_cost_distribution_lines_all cdl,
759: gl_period_STATUSES gl,
760: pa_tasks pt

Line 800: from pa_expenditure_items_all ei1,

796: )
797: or (ei.system_linkage_function = 'BTC'
798: /* 7531681 start */
799: and exists (select null
800: from pa_expenditure_items_all ei1,
801: pa_cost_distribution_lines_all cdl1
802: where ( cdl1.burden_sum_source_run_id = ei.burden_sum_dest_run_id
803: and cdl1.project_id = p_project_id
804: and ei1.expenditure_item_id = cdl1.expenditure_item_id

Line 826: select null from pa_expenditure_items_all ei1,

822: (ei1.system_linkage_function in ('ST', 'OT')
823: and ei1.po_line_id is not null)
824: )
825: UNION ALL
826: select null from pa_expenditure_items_all ei1,
827: pa_aud_cost_dist_lines aud
828: WHERE
829: ( aud.burden_sum_source_run_id = ei.burden_sum_dest_run_id
830: and aud.expenditure_item_id = ei1.expenditure_item_id

Line 853: -- from pa_expenditure_items_all ei1,

849: )
850: )));
851: /* 7531681 end */
852: --Bug 2795051
853: -- from pa_expenditure_items_all ei1,
854: -- and ei1.expenditure_item_id = cdl1.expenditure_item_id
855: -- and ei1.system_linkage_function = 'VI'
856: --Bug 3019361
857: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids

Line 859: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally

855: -- and ei1.system_linkage_function = 'VI'
856: --Bug 3019361
857: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids
858: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
859: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
860: /* 7531681 and exists (select null
861: from pa_expenditure_items_all ei1,
862: pa_cost_distribution_lines_all cdl1,
863: pa_aud_cost_dist_lines aud

Line 861: from pa_expenditure_items_all ei1,

857: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids
858: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
859: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
860: /* 7531681 and exists (select null
861: from pa_expenditure_items_all ei1,
862: pa_cost_distribution_lines_all cdl1,
863: pa_aud_cost_dist_lines aud
864: --PA.M added outer join to cdl1 and aud plus changed the or to and
865: -- cos if there are no records in aud,

Line 953: from pa_expenditure_items_all ei,

949: ,cdl.expenditure_item_id
950: ,cdl.line_num
951: --PA.M selecting -99 for parent bc pkt for CWK BTC EIs
952: ,decode(ei.system_linkage_function, 'BTC', decode(nvl(ei.po_line_id,-99), -99, null, -99), null)
953: from pa_expenditure_items_all ei,
954: -- pa_expenditures_all exp, -- 7531681
955: pa_cost_distribution_lines_all cdl,
956: gl_period_STATUSES gl,
957: pa_tasks pt

Line 997: from pa_expenditure_items_all ei1,

993: )
994: or (ei.system_linkage_function = 'BTC'
995: /* 7531681 start */
996: and exists (select null
997: from pa_expenditure_items_all ei1,
998: pa_cost_distribution_lines_all cdl1
999: where ( cdl1.burden_sum_source_run_id = ei.burden_sum_dest_run_id
1000: and cdl1.project_id = p_project_id
1001: and ei1.expenditure_item_id = cdl1.expenditure_item_id

Line 1022: select null from pa_expenditure_items_all ei1,

1018: (ei1.system_linkage_function in ('ST', 'OT')
1019: and ei1.po_line_id is not null)
1020: )
1021: UNION ALL
1022: select null from pa_expenditure_items_all ei1,
1023: pa_aud_cost_dist_lines aud
1024: WHERE
1025: ( aud.burden_sum_source_run_id = ei.burden_sum_dest_run_id
1026: and aud.expenditure_item_id = ei1.expenditure_item_id

Line 1051: -- from pa_expenditure_items_all ei1,

1047: )
1048: );
1049: /* 7531681 end */
1050: --Bug 2795051
1051: -- from pa_expenditure_items_all ei1,
1052: -- and ei1.expenditure_item_id = cdl1.expenditure_item_id
1053: -- and ei1.system_linkage_function = 'VI'
1054: --Bug 3019361
1055: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids

Line 1057: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally

1053: -- and ei1.system_linkage_function = 'VI'
1054: --Bug 3019361
1055: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids
1056: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
1057: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
1058: /* 7531681 and exists (select null
1059: from pa_expenditure_items_all ei1,
1060: pa_cost_distribution_lines_all cdl1,
1061: pa_aud_cost_dist_lines aud

Line 1059: from pa_expenditure_items_all ei1,

1055: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids
1056: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
1057: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
1058: /* 7531681 and exists (select null
1059: from pa_expenditure_items_all ei1,
1060: pa_cost_distribution_lines_all cdl1,
1061: pa_aud_cost_dist_lines aud
1062: --PA.M added outer join to cdl1 and aud plus changed the or to and
1063: -- cos if there are no records in aud,