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_EXPENDITURES_ALL

Line 719: nvl(ei.override_to_organization_id,( select exp.incurred_by_organization_id from pa_expenditures_all exp

715: cdl.task_id,
716: ei.EXPENDITURE_TYPE,
717: trunc(ei.EXPENDITURE_ITEM_DATE) expenditure_item_date,
718: -- nvl(ei.override_to_organization_id,exp.incurred_by_organization_id) organization_id, -- 7531681
719: nvl(ei.override_to_organization_id,( select exp.incurred_by_organization_id from pa_expenditures_all exp
720: where exp.expenditure_id = ei.expenditure_id)) organization_id, -- 7531681
721: gl.PERIOD_NAME,
722: gl.PERIOD_YEAR,
723: gl.PERIOD_NUM,

Line 757: -- pa_expenditures_all exp, -- 7531681

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
761: where cdl.project_id = p_project_id

Line 915: nvl(ei.override_to_organization_id,( select exp.incurred_by_organization_id from pa_expenditures_all exp

911: cdl.task_id,
912: ei.EXPENDITURE_TYPE,
913: trunc(ei.EXPENDITURE_ITEM_DATE) expenditure_item_date,
914: -- nvl(ei.override_to_organization_id,exp.incurred_by_organization_id) organization_id, -- 7531681
915: nvl(ei.override_to_organization_id,( select exp.incurred_by_organization_id from pa_expenditures_all exp
916: where exp.expenditure_id = ei.expenditure_id)) organization_id, -- 7531681
917:
918: gl.PERIOD_NAME,
919: gl.PERIOD_YEAR,

Line 954: -- pa_expenditures_all exp, -- 7531681

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
958: where cdl.project_id = p_project_id