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_AUD_COST_DIST_LINES

Line 827: pa_aud_cost_dist_lines aud

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
831: )

Line 857: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids

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
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,

Line 863: pa_aud_cost_dist_lines aud

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,
866: -- then this will not pick up the BTC txns
867: where ( cdl1.burden_sum_source_run_id(+) = ei.burden_sum_dest_run_id

Line 1023: pa_aud_cost_dist_lines aud

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
1027: )

Line 1055: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids

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
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,

Line 1061: pa_aud_cost_dist_lines aud

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,
1064: -- then this will not pick up the BTC txns
1065: where ( cdl1.burden_sum_source_run_id(+) = ei.burden_sum_dest_run_id