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 754: from pa_expenditure_items_all ei,

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

Line 784: -- from pa_expenditure_items_all ei1,

780: and ei.po_line_id is not null)
781: )
782: or (ei.system_linkage_function = 'BTC'
783: --Bug 2795051
784: -- from pa_expenditure_items_all ei1,
785: -- and ei1.expenditure_item_id = cdl1.expenditure_item_id
786: -- and ei1.system_linkage_function = 'VI'
787: --Bug 3019361
788: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids

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

786: -- and ei1.system_linkage_function = 'VI'
787: --Bug 3019361
788: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids
789: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
790: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
791: and exists (select null
792: from pa_expenditure_items_all ei1,
793: pa_cost_distribution_lines_all cdl1,
794: pa_aud_cost_dist_lines aud

Line 792: from pa_expenditure_items_all ei1,

788: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids
789: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
790: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
791: and exists (select null
792: from pa_expenditure_items_all ei1,
793: pa_cost_distribution_lines_all cdl1,
794: pa_aud_cost_dist_lines aud
795: --PA.M added outer join to cdl1 and aud plus changed the or to and
796: -- cos if there are no records in aud,

Line 868: from pa_expenditure_items_all ei,

864: ,cdl.expenditure_item_id
865: ,cdl.line_num
866: --PA.M selecting -99 for parent bc pkt for CWK BTC EIs
867: ,decode(ei.system_linkage_function, 'BTC', decode(nvl(ei.po_line_id,-99), -99, null, -99), null)
868: from pa_expenditure_items_all ei,
869: pa_expenditures_all exp,
870: pa_cost_distribution_lines_all cdl,
871: gl_period_STATUSES gl,
872: pa_tasks pt

Line 898: -- from pa_expenditure_items_all ei1,

894: and ei.po_line_id is not null)
895: )
896: or (ei.system_linkage_function = 'BTC'
897: --Bug 2795051
898: -- from pa_expenditure_items_all ei1,
899: -- and ei1.expenditure_item_id = cdl1.expenditure_item_id
900: -- and ei1.system_linkage_function = 'VI'
901: --Bug 3019361
902: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids

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

900: -- and ei1.system_linkage_function = 'VI'
901: --Bug 3019361
902: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids
903: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
904: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
905: and exists (select null
906: from pa_expenditure_items_all ei1,
907: pa_cost_distribution_lines_all cdl1,
908: pa_aud_cost_dist_lines aud

Line 906: from pa_expenditure_items_all ei1,

902: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids
903: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
904: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
905: and exists (select null
906: from pa_expenditure_items_all ei1,
907: pa_cost_distribution_lines_all cdl1,
908: pa_aud_cost_dist_lines aud
909: --PA.M added outer join to cdl1 and aud plus changed the or to and
910: -- cos if there are no records in aud,