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.

[Home] [Help]

VIEW: APPS.PA_RES_MAP_BTC_V

Source

View Text - Preformatted


SELECT cdl1.expenditure_item_id expenditure_item_id ,cdl1.project_id project_id ,cdl1.line_num line_num ,cdl1.rowid cdl_rowid ,cdl1.request_id request_id ,ei1.task_id task_id ,t.top_task_id top_task_id ,NVL(ei1.override_to_organization_id, exp.incurred_by_organization_id) organization_id ,ei1.job_id job_id ,ei1.expenditure_type expenditure_type ,exp.incurred_by_person_id person_id ,exptype.expenditure_category expenditure_category ,ei1.system_linkage_function system_linkage_function ,glp.start_date gl_start_date ,pa_funds_control_utils.get_encum_type_id(NVL(cdl1.project_id, -99) ,'STD' ) encum_type_id ,(SELECT cdl3.system_reference1 FROM pa_cost_distribution_lines cdl3 WHERE ei1.burden_sum_dest_run_id = cdl3.burden_sum_source_run_id AND rownum =1) vendor_id ,(select bv.budget_version_id from pa_budget_versions bv ,pa_budgetary_control_options pbct where bv.project_id = ei1.project_id and bv.current_flag = 'Y' and bv.budget_status_code = 'B' and pbct.project_id = bv.project_id and pbct.bdgt_cntrl_flag = 'Y' and bv.budget_type_code = pbct.budget_type_code and (pbct.external_budget_code = 'GL' OR pbct.external_budget_code is NULL )) budget_version_id ,(select bv.resource_list_id from pa_budget_versions bv ,pa_budgetary_control_options pbct where bv.project_id = ei1.project_id and bv.current_flag = 'Y' and bv.budget_status_code = 'B' and pbct.project_id = bv.project_id and pbct.bdgt_cntrl_flag = 'Y' and bv.budget_type_code = pbct.budget_type_code and (pbct.external_budget_code = 'GL' OR pbct.external_budget_code is NULL )) resource_list_id ,(select pbm.entry_level_code from pa_budget_versions bv ,pa_budget_entry_methods pbm ,pa_budgetary_control_options pbct where bv.project_id = ei1.project_id and bv.current_flag = 'Y' and bv.budget_status_code = 'B' and bv.budget_entry_method_code = pbm.budget_entry_method_code and pbct.project_id = bv.project_id and pbct.bdgt_cntrl_flag = 'Y' and bv.budget_type_code = pbct.budget_type_code and (pbct.external_budget_code = 'GL' OR pbct.external_budget_code is NULL )) entry_level_code ,cdl1.system_reference1 system_reference1 ,decode(ei1.system_linkage_function,'VI',ei1.document_header_id,cdl1.system_reference2) system_reference2 ,cdl1.system_reference3 system_reference3 ,ei1.po_line_id po_line_id ,ei1.adjustment_type ei_adjustment_type ,pt.project_type project_type ,pt.burden_amt_display_method burden_amt_disp_method ,cdl1.dr_code_combination_id ,imp.org_id FROM pa_expenditure_items_all ei1 ,pa_cost_distribution_lines_all cdl1 ,pa_projects_all pp ,pa_project_types_all pt ,pa_expenditure_types exptype ,pa_expenditures_all exp ,pa_tasks t ,gl_periods glp ,gl_sets_of_books glsob ,pa_implementations imp WHERE ei1.cost_dist_rejection_code IS NULL AND exptype.expenditure_type = ei1.expenditure_type AND exp.expenditure_id = ei1.expenditure_id AND cdl1.pa_date BETWEEN glp.start_date AND TRUNC(glp.end_date) AND glsob.period_set_name = glp.period_set_name AND glsob.accounted_period_type = glp.period_type AND glsob.set_of_books_id = imp.set_of_books_id AND ei1.system_linkage_function = 'BTC' AND ei1.cost_distributed_flag = 'S' AND ei1.expenditure_item_id = cdl1.expenditure_item_id AND t.task_id = ei1.task_id AND cdl1.line_type = 'R' AND ei1.project_id = pp.project_id AND pp.project_type = pt.project_type AND pt.org_id = pp.org_id AND pa_funds_control_utils.get_bdgt_link(NVL( cdl1.project_id, -99) ,'STD' ) = 'Y' AND EXISTS ( SELECT NULL FROM pa_cost_distribution_lines cdl2 ,pa_expenditure_items ei2 ,pa_aud_cost_dist_lines cdl_aud WHERE (ei2.expenditure_item_id = cdl2.expenditure_item_id(+) AND ei1.burden_sum_dest_run_id = cdl2.burden_sum_source_run_id(+) ) AND (ei2.expenditure_item_id = cdl_aud.expenditure_item_id(+) AND ei1.burden_sum_dest_run_id = cdl_aud.burden_sum_source_run_id(+)) AND ei2.expenditure_item_id = cdl2.expenditure_item_id AND ei2.system_linkage_function = NVL(ei1.src_system_linkage_function,ei2.system_linkage_function) AND ( ei2.system_linkage_function = ('VI') OR (ei2.system_linkage_function IN ('ST','OT') and ei2.po_line_id is NOT NULL AND ei1.po_line_id = ei2.po_line_id ) ) ) AND imp.org_id = exp.org_id

View Text - HTML Formatted

SELECT CDL1.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, CDL1.PROJECT_ID PROJECT_ID
, CDL1.LINE_NUM LINE_NUM
, CDL1.ROWID CDL_ROWID
, CDL1.REQUEST_ID REQUEST_ID
, EI1.TASK_ID TASK_ID
, T.TOP_TASK_ID TOP_TASK_ID
, NVL(EI1.OVERRIDE_TO_ORGANIZATION_ID
, EXP.INCURRED_BY_ORGANIZATION_ID) ORGANIZATION_ID
, EI1.JOB_ID JOB_ID
, EI1.EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXP.INCURRED_BY_PERSON_ID PERSON_ID
, EXPTYPE.EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY
, EI1.SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, GLP.START_DATE GL_START_DATE
, PA_FUNDS_CONTROL_UTILS.GET_ENCUM_TYPE_ID(NVL(CDL1.PROJECT_ID
, -99)
, 'STD' ) ENCUM_TYPE_ID
, (SELECT CDL3.SYSTEM_REFERENCE1
FROM PA_COST_DISTRIBUTION_LINES CDL3
WHERE EI1.BURDEN_SUM_DEST_RUN_ID = CDL3.BURDEN_SUM_SOURCE_RUN_ID
AND ROWNUM =1) VENDOR_ID
, (SELECT BV.BUDGET_VERSION_ID
FROM PA_BUDGET_VERSIONS BV
, PA_BUDGETARY_CONTROL_OPTIONS PBCT
WHERE BV.PROJECT_ID = EI1.PROJECT_ID
AND BV.CURRENT_FLAG = 'Y'
AND BV.BUDGET_STATUS_CODE = 'B'
AND PBCT.PROJECT_ID = BV.PROJECT_ID
AND PBCT.BDGT_CNTRL_FLAG = 'Y'
AND BV.BUDGET_TYPE_CODE = PBCT.BUDGET_TYPE_CODE
AND (PBCT.EXTERNAL_BUDGET_CODE = 'GL' OR PBCT.EXTERNAL_BUDGET_CODE IS NULL )) BUDGET_VERSION_ID
, (SELECT BV.RESOURCE_LIST_ID
FROM PA_BUDGET_VERSIONS BV
, PA_BUDGETARY_CONTROL_OPTIONS PBCT
WHERE BV.PROJECT_ID = EI1.PROJECT_ID
AND BV.CURRENT_FLAG = 'Y'
AND BV.BUDGET_STATUS_CODE = 'B'
AND PBCT.PROJECT_ID = BV.PROJECT_ID
AND PBCT.BDGT_CNTRL_FLAG = 'Y'
AND BV.BUDGET_TYPE_CODE = PBCT.BUDGET_TYPE_CODE
AND (PBCT.EXTERNAL_BUDGET_CODE = 'GL' OR PBCT.EXTERNAL_BUDGET_CODE IS NULL )) RESOURCE_LIST_ID
, (SELECT PBM.ENTRY_LEVEL_CODE
FROM PA_BUDGET_VERSIONS BV
, PA_BUDGET_ENTRY_METHODS PBM
, PA_BUDGETARY_CONTROL_OPTIONS PBCT
WHERE BV.PROJECT_ID = EI1.PROJECT_ID
AND BV.CURRENT_FLAG = 'Y'
AND BV.BUDGET_STATUS_CODE = 'B'
AND BV.BUDGET_ENTRY_METHOD_CODE = PBM.BUDGET_ENTRY_METHOD_CODE
AND PBCT.PROJECT_ID = BV.PROJECT_ID
AND PBCT.BDGT_CNTRL_FLAG = 'Y'
AND BV.BUDGET_TYPE_CODE = PBCT.BUDGET_TYPE_CODE
AND (PBCT.EXTERNAL_BUDGET_CODE = 'GL' OR PBCT.EXTERNAL_BUDGET_CODE IS NULL )) ENTRY_LEVEL_CODE
, CDL1.SYSTEM_REFERENCE1 SYSTEM_REFERENCE1
, DECODE(EI1.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, EI1.DOCUMENT_HEADER_ID
, CDL1.SYSTEM_REFERENCE2) SYSTEM_REFERENCE2
, CDL1.SYSTEM_REFERENCE3 SYSTEM_REFERENCE3
, EI1.PO_LINE_ID PO_LINE_ID
, EI1.ADJUSTMENT_TYPE EI_ADJUSTMENT_TYPE
, PT.PROJECT_TYPE PROJECT_TYPE
, PT.BURDEN_AMT_DISPLAY_METHOD BURDEN_AMT_DISP_METHOD
, CDL1.DR_CODE_COMBINATION_ID
, IMP.ORG_ID
FROM PA_EXPENDITURE_ITEMS_ALL EI1
, PA_COST_DISTRIBUTION_LINES_ALL CDL1
, PA_PROJECTS_ALL PP
, PA_PROJECT_TYPES_ALL PT
, PA_EXPENDITURE_TYPES EXPTYPE
, PA_EXPENDITURES_ALL EXP
, PA_TASKS T
, GL_PERIODS GLP
, GL_SETS_OF_BOOKS GLSOB
, PA_IMPLEMENTATIONS IMP
WHERE EI1.COST_DIST_REJECTION_CODE IS NULL
AND EXPTYPE.EXPENDITURE_TYPE = EI1.EXPENDITURE_TYPE
AND EXP.EXPENDITURE_ID = EI1.EXPENDITURE_ID
AND CDL1.PA_DATE BETWEEN GLP.START_DATE
AND TRUNC(GLP.END_DATE)
AND GLSOB.PERIOD_SET_NAME = GLP.PERIOD_SET_NAME
AND GLSOB.ACCOUNTED_PERIOD_TYPE = GLP.PERIOD_TYPE
AND GLSOB.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID
AND EI1.SYSTEM_LINKAGE_FUNCTION = 'BTC'
AND EI1.COST_DISTRIBUTED_FLAG = 'S'
AND EI1.EXPENDITURE_ITEM_ID = CDL1.EXPENDITURE_ITEM_ID
AND T.TASK_ID = EI1.TASK_ID
AND CDL1.LINE_TYPE = 'R'
AND EI1.PROJECT_ID = PP.PROJECT_ID
AND PP.PROJECT_TYPE = PT.PROJECT_TYPE
AND PT.ORG_ID = PP.ORG_ID
AND PA_FUNDS_CONTROL_UTILS.GET_BDGT_LINK(NVL( CDL1.PROJECT_ID
, -99)
, 'STD' ) = 'Y'
AND EXISTS ( SELECT NULL
FROM PA_COST_DISTRIBUTION_LINES CDL2
, PA_EXPENDITURE_ITEMS EI2
, PA_AUD_COST_DIST_LINES CDL_AUD
WHERE (EI2.EXPENDITURE_ITEM_ID = CDL2.EXPENDITURE_ITEM_ID(+)
AND EI1.BURDEN_SUM_DEST_RUN_ID = CDL2.BURDEN_SUM_SOURCE_RUN_ID(+) )
AND (EI2.EXPENDITURE_ITEM_ID = CDL_AUD.EXPENDITURE_ITEM_ID(+)
AND EI1.BURDEN_SUM_DEST_RUN_ID = CDL_AUD.BURDEN_SUM_SOURCE_RUN_ID(+))
AND EI2.EXPENDITURE_ITEM_ID = CDL2.EXPENDITURE_ITEM_ID
AND EI2.SYSTEM_LINKAGE_FUNCTION = NVL(EI1.SRC_SYSTEM_LINKAGE_FUNCTION
, EI2.SYSTEM_LINKAGE_FUNCTION)
AND ( EI2.SYSTEM_LINKAGE_FUNCTION = ('VI') OR (EI2.SYSTEM_LINKAGE_FUNCTION IN ('ST'
, 'OT')
AND EI2.PO_LINE_ID IS NOT NULL
AND EI1.PO_LINE_ID = EI2.PO_LINE_ID ) ) )
AND IMP.ORG_ID = EXP.ORG_ID