VIEW: APPS.PA_GL_UNCOST_EXCEPT_SUM_V

Source

View Text - Preformatted

SELECT PP.PROJECT_ID , PP.NAME , EI.TASK_ID TASK_ID , TT.TASK_NAME , EI.EXPENDITURE_ID EXPENDITURE_ID , EI.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID , EI.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE , EI.EXPENDITURE_TYPE EXPENDITURE_TYPE , nvl(EI.ORGANIZATION_ID,EI.OVERRIDE_TO_ORGANIZATION_ID) , PA_EXPENDITURES_UTILS.GetOrgTlName(nvl(EI.ORGANIZATION_ID,EI.OVERRIDE_TO_ORGANIZATION_ID)) , PRD.PERIOD_NAME PERIOD_NAME , PPA.period_name PA_PERIOD_NAME , decode(ei.cost_dist_rejection_code,null,'NO_COST_DIST',ei.cost_dist_rejection_code) exception_code , EI.QUANTITY QUANTITY , EI.DENOM_CURRENCY_CODE , EI.DENOM_RAW_COST , EI.DENOM_BURDENED_COST , EI.ACCT_CURRENCY_CODE , EI.ACCT_RAW_COST , EI.ACCT_BURDENED_COST , EI.PROJECT_CURRENCY_CODE , PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP', 'NO_COST_DIST', NULL, 'R') EXCEPTION_REASON , PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP', 'NO_COST_DIST', NULL, 'A') CORRECTIVE_ACTION , EI.ORG_ID ORG_ID , IMP.same_pa_gl_period , PA_EXPENDITURES_UTILS.GetOrgTlName(ei.org_id) , IMP.SET_OF_BOOKS_ID , emp.full_name person_name , exp.incurred_by_person_id person_id , exp.expenditure_group expenditure_batch , null vendor_id , null vendor_name , null vendor_number , EI.system_linkage_function , EI.PRVDR_ACCRUAL_DATE FROM PA_EXPENDITURE_ITEMS_ALL EI, PA_IMPLEMENTATIONS_ALL IMP, GL_PERIOD_STATUSES PRD, PA_PROJECTS_ALL PP, PA_TASKS TT, PA_EXPENDITURES_ALL EXP, PER_PEOPLE_F EMP, PA_PERIODS_ALL PPA WHERE EI.COST_DISTRIBUTED_FLAG = 'N' AND EI.TASK_ID = TT.TASK_ID AND TT.PROJECT_ID = PP.PROJECT_ID AND EMP.PERSON_ID(+) = EXP.INCURRED_BY_PERSON_ID AND trunc(sysdate) between emp.effective_start_date and emp.effective_end_date AND EXP.EXPENDITURE_ID(+) = EI.EXPENDITURE_ID AND ( (EI.SYSTEM_LINKAGE_FUNCTION <> 'PJ' AND EI.EXPENDITURE_ITEM_DATE BETWEEN PRD.START_DATE AND PRD.END_DATE) OR ( EI.SYSTEM_LINKAGE_FUNCTION = 'PJ' AND nvl(EI.PRVDR_ACCRUAL_DATE,EI.EXPENDITURE_ITEM_DATE) BETWEEN PRD.START_DATE AND PRD.END_DATE) ) AND PRD.APPLICATION_ID = 8721 AND PRD.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID AND PRD.ADJUSTMENT_PERIOD_FLAG = 'N' AND NVL(EI.org_id,-99) =IMP.org_id AND EI.expenditure_item_date BETWEEN PPA.start_date AND PPA.end_date AND PPA.ORG_ID = IMP.ORG_ID UNION SELECT PP.PROJECT_ID , PP.NAME , EI.TASK_ID TASK_ID , TT.TASK_NAME , EI.EXPENDITURE_ID EXPENDITURE_ID , EI.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID , EI.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE , EI.EXPENDITURE_TYPE EXPENDITURE_TYPE , nvl(EI.ORGANIZATION_ID,EI.OVERRIDE_TO_ORGANIZATION_ID) , PA_EXPENDITURES_UTILS.GetOrgTlName(nvl(EI.ORGANIZATION_ID,EI.OVERRIDE_TO_ORGANIZATION_ID)) , PRD.PERIOD_NAME PERIOD_NAME , PPA.PERIOD_NAME PA_PERIOD_NAME , decode(ei.cost_dist_rejection_code,null,'NO_COST_DIST',ei.cost_dist_rejection_code) exception_code , EI.QUANTITY QUANTITY , EI.DENOM_CURRENCY_CODE , EI.DENOM_RAW_COST , EI.DENOM_BURDENED_COST , EI.ACCT_CURRENCY_CODE , EI.ACCT_RAW_COST , EI.ACCT_BURDENED_COST , EI.PROJECT_CURRENCY_CODE , PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP', 'NO_COST_DIST', NULL, 'R') EXCEPTION_REASON , PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP', 'NO_COST_DIST', NULL, 'A') CORRECTIVE_ACTION , EI.ORG_ID ORG_ID , IMP.same_pa_gl_period , PA_EXPENDITURES_UTILS.GetOrgTlName(ei.org_id) , IMP.SET_OF_BOOKS_ID , null person_name , exp.incurred_by_person_id person_id , exp.expenditure_group expenditure_batch , cdl.system_reference1 vendor_id , vnd.vendor_name vendor_name , vnd.segment1 vendor_number , EI.system_linkage_function , EI.PRVDR_ACCRUAL_DATE FROM PA_EXPENDITURE_ITEMS_ALL EI, PA_IMPLEMENTATIONS_ALL IMP, GL_PERIOD_STATUSES PRD, PA_PROJECTS_ALL PP, PA_TASKS TT, PA_EXPENDITURES_ALL EXP, PA_COST_DISTRIBUTION_LINES_ALL cdl, PO_VENDORS VND, PA_PERIODS_ALL PPA WHERE EI.COST_DISTRIBUTED_FLAG = 'N' AND EI.TASK_ID = TT.TASK_ID AND TT.PROJECT_ID = PP.PROJECT_ID AND nvl(EXP.INCURRED_BY_PERSON_ID,0) = 0 AND EXP.EXPENDITURE_ID = EI.EXPENDITURE_ID AND ( (EI.SYSTEM_LINKAGE_FUNCTION <> 'PJ' AND EI.EXPENDITURE_ITEM_DATE BETWEEN PRD.START_DATE AND PRD.END_DATE) OR ( EI.SYSTEM_LINKAGE_FUNCTION = 'PJ' AND nvl(EI.PRVDR_ACCRUAL_DATE,EI.EXPENDITURE_ITEM_DATE) BETWEEN PRD.START_DATE AND PRD.END_DATE) ) AND PRD.APPLICATION_ID = 8721 AND PRD.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID AND PRD.ADJUSTMENT_PERIOD_FLAG = 'N' AND NVL(EI.org_id,-99) =IMP.org_id AND cdl.expenditure_item_id = ei.expenditure_item_id(+) AND cdl.line_type = 'R' AND ei.transaction_source in ('AP EXPENSE','AP INVOICE') AND ei.system_linkage_function in ('VI','ER') AND cdl.system_reference1 is not null AND cdl.system_reference1 = vnd.vendor_id AND EI.expenditure_item_date BETWEEN PPA.start_date AND PPA.end_date AND PPA.ORG_ID = IMP.ORG_ID UNION SELECT PP.PROJECT_ID , PP.NAME , EI.TASK_ID TASK_ID , TT.TASK_NAME , EI.EXPENDITURE_ID EXPENDITURE_ID , EI.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID , EI.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE , EI.EXPENDITURE_TYPE EXPENDITURE_TYPE , nvl(EI.ORGANIZATION_ID,EI.OVERRIDE_TO_ORGANIZATION_ID) , PA_EXPENDITURES_UTILS.GetOrgTlName(nvl(EI.ORGANIZATION_ID,EI.OVERRIDE_TO_ORGANIZATION_ID)) , PRD.PERIOD_NAME PERIOD_NAME , PPA.PERIOD_NAME PA_PERIOD_NAME , decode(ei.cost_dist_rejection_code,null,'NO_COST_DIST',ei.cost_dist_rejection_code) exception_code , EI.QUANTITY QUANTITY , EI.DENOM_CURRENCY_CODE , EI.DENOM_RAW_COST , EI.DENOM_BURDENED_COST , EI.ACCT_CURRENCY_CODE , EI.ACCT_RAW_COST , EI.ACCT_BURDENED_COST , EI.PROJECT_CURRENCY_CODE , PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP', 'NO_COST_DIST', NULL, 'R') EXCEPTION_REASON , PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP', 'NO_COST_DIST', NULL, 'A') CORRECTIVE_ACTION , EI.ORG_ID ORG_ID , IMP.same_pa_gl_period , PA_EXPENDITURES_UTILS.GetOrgTlName(ei.org_id) , IMP.SET_OF_BOOKS_ID , null person_name , exp.incurred_by_person_id person_id , exp.expenditure_group expenditure_batch , null vendor_id , null vendor_name , null vendor_number , EI.system_linkage_function , EI.PRVDR_ACCRUAL_DATE FROM PA_EXPENDITURE_ITEMS_ALL EI, PA_IMPLEMENTATIONS_ALL IMP, GL_PERIOD_STATUSES PRD, PA_PROJECTS_ALL PP, PA_TASKS TT, PA_EXPENDITURES_ALL EXP, PA_PERIODS_ALL PPA WHERE EI.COST_DISTRIBUTED_FLAG = 'N' AND EI.TASK_ID = TT.TASK_ID AND TT.PROJECT_ID = PP.PROJECT_ID AND EXP.INCURRED_BY_PERSON_ID is NULL AND EXP.EXPENDITURE_ID(+) = EI.EXPENDITURE_ID AND ( (EI.SYSTEM_LINKAGE_FUNCTION <> 'PJ' AND EI.EXPENDITURE_ITEM_DATE BETWEEN PRD.START_DATE AND PRD.END_DATE) OR ( EI.SYSTEM_LINKAGE_FUNCTION = 'PJ' AND nvl(EI.PRVDR_ACCRUAL_DATE,EI.EXPENDITURE_ITEM_DATE) BETWEEN PRD.START_DATE AND PRD.END_DATE) ) AND PRD.APPLICATION_ID = 8721 AND PRD.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID AND PRD.ADJUSTMENT_PERIOD_FLAG = 'N' AND NVL(EI.org_id,-99) =IMP.org_id AND ((EI.SYSTEM_LINKAGE_FUNCTION NOT IN ('VI', 'ER')) OR (NOT EXISTS (SELECT 1 FROM PA_COST_DISTRIBUTION_LINES_ALL CDL WHERE CDL.expenditure_item_id = EI.expenditure_item_id AND CDL.LINE_TYPE = 'R' AND CDL.SYSTEM_REFERENCE1 IS NOT NULL))) AND EI.expenditure_item_date BETWEEN PPA.start_date AND PPA.end_date AND PPA.ORG_ID = IMP.ORG_ID

View Text - HTML Formatted

SELECT PP.PROJECT_ID
, PP.NAME
, EI.TASK_ID TASK_ID
, TT.TASK_NAME
, EI.EXPENDITURE_ID EXPENDITURE_ID
, EI.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, EI.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EI.EXPENDITURE_TYPE EXPENDITURE_TYPE
, NVL(EI.ORGANIZATION_ID
, EI.OVERRIDE_TO_ORGANIZATION_ID)
, PA_EXPENDITURES_UTILS.GETORGTLNAME(NVL(EI.ORGANIZATION_ID
, EI.OVERRIDE_TO_ORGANIZATION_ID))
, PRD.PERIOD_NAME PERIOD_NAME
, PPA.PERIOD_NAME PA_PERIOD_NAME
, DECODE(EI.COST_DIST_REJECTION_CODE
, NULL
, 'NO_COST_DIST'
, EI.COST_DIST_REJECTION_CODE) EXCEPTION_CODE
, EI.QUANTITY QUANTITY
, EI.DENOM_CURRENCY_CODE
, EI.DENOM_RAW_COST
, EI.DENOM_BURDENED_COST
, EI.ACCT_CURRENCY_CODE
, EI.ACCT_RAW_COST
, EI.ACCT_BURDENED_COST
, EI.PROJECT_CURRENCY_CODE
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP'
, 'NO_COST_DIST'
, NULL
, 'R') EXCEPTION_REASON
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP'
, 'NO_COST_DIST'
, NULL
, 'A') CORRECTIVE_ACTION
, EI.ORG_ID ORG_ID
, IMP.SAME_PA_GL_PERIOD
, PA_EXPENDITURES_UTILS.GETORGTLNAME(EI.ORG_ID)
, IMP.SET_OF_BOOKS_ID
, EMP.FULL_NAME PERSON_NAME
, EXP.INCURRED_BY_PERSON_ID PERSON_ID
, EXP.EXPENDITURE_GROUP EXPENDITURE_BATCH
, NULL VENDOR_ID
, NULL VENDOR_NAME
, NULL VENDOR_NUMBER
, EI.SYSTEM_LINKAGE_FUNCTION
, EI.PRVDR_ACCRUAL_DATE
FROM PA_EXPENDITURE_ITEMS_ALL EI
, PA_IMPLEMENTATIONS_ALL IMP
, GL_PERIOD_STATUSES PRD
, PA_PROJECTS_ALL PP
, PA_TASKS TT
, PA_EXPENDITURES_ALL EXP
, PER_PEOPLE_F EMP
, PA_PERIODS_ALL PPA
WHERE EI.COST_DISTRIBUTED_FLAG = 'N'
AND EI.TASK_ID = TT.TASK_ID
AND TT.PROJECT_ID = PP.PROJECT_ID
AND EMP.PERSON_ID(+) = EXP.INCURRED_BY_PERSON_ID
AND TRUNC(SYSDATE) BETWEEN EMP.EFFECTIVE_START_DATE
AND EMP.EFFECTIVE_END_DATE
AND EXP.EXPENDITURE_ID(+) = EI.EXPENDITURE_ID
AND ( (EI.SYSTEM_LINKAGE_FUNCTION <> 'PJ'
AND EI.EXPENDITURE_ITEM_DATE BETWEEN PRD.START_DATE
AND PRD.END_DATE) OR ( EI.SYSTEM_LINKAGE_FUNCTION = 'PJ'
AND NVL(EI.PRVDR_ACCRUAL_DATE
, EI.EXPENDITURE_ITEM_DATE) BETWEEN PRD.START_DATE
AND PRD.END_DATE) )
AND PRD.APPLICATION_ID = 8721
AND PRD.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID
AND PRD.ADJUSTMENT_PERIOD_FLAG = 'N'
AND NVL(EI.ORG_ID
, -99) =IMP.ORG_ID
AND EI.EXPENDITURE_ITEM_DATE BETWEEN PPA.START_DATE
AND PPA.END_DATE
AND PPA.ORG_ID = IMP.ORG_ID UNION SELECT PP.PROJECT_ID
, PP.NAME
, EI.TASK_ID TASK_ID
, TT.TASK_NAME
, EI.EXPENDITURE_ID EXPENDITURE_ID
, EI.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, EI.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EI.EXPENDITURE_TYPE EXPENDITURE_TYPE
, NVL(EI.ORGANIZATION_ID
, EI.OVERRIDE_TO_ORGANIZATION_ID)
, PA_EXPENDITURES_UTILS.GETORGTLNAME(NVL(EI.ORGANIZATION_ID
, EI.OVERRIDE_TO_ORGANIZATION_ID))
, PRD.PERIOD_NAME PERIOD_NAME
, PPA.PERIOD_NAME PA_PERIOD_NAME
, DECODE(EI.COST_DIST_REJECTION_CODE
, NULL
, 'NO_COST_DIST'
, EI.COST_DIST_REJECTION_CODE) EXCEPTION_CODE
, EI.QUANTITY QUANTITY
, EI.DENOM_CURRENCY_CODE
, EI.DENOM_RAW_COST
, EI.DENOM_BURDENED_COST
, EI.ACCT_CURRENCY_CODE
, EI.ACCT_RAW_COST
, EI.ACCT_BURDENED_COST
, EI.PROJECT_CURRENCY_CODE
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP'
, 'NO_COST_DIST'
, NULL
, 'R') EXCEPTION_REASON
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP'
, 'NO_COST_DIST'
, NULL
, 'A') CORRECTIVE_ACTION
, EI.ORG_ID ORG_ID
, IMP.SAME_PA_GL_PERIOD
, PA_EXPENDITURES_UTILS.GETORGTLNAME(EI.ORG_ID)
, IMP.SET_OF_BOOKS_ID
, NULL PERSON_NAME
, EXP.INCURRED_BY_PERSON_ID PERSON_ID
, EXP.EXPENDITURE_GROUP EXPENDITURE_BATCH
, CDL.SYSTEM_REFERENCE1 VENDOR_ID
, VND.VENDOR_NAME VENDOR_NAME
, VND.SEGMENT1 VENDOR_NUMBER
, EI.SYSTEM_LINKAGE_FUNCTION
, EI.PRVDR_ACCRUAL_DATE
FROM PA_EXPENDITURE_ITEMS_ALL EI
, PA_IMPLEMENTATIONS_ALL IMP
, GL_PERIOD_STATUSES PRD
, PA_PROJECTS_ALL PP
, PA_TASKS TT
, PA_EXPENDITURES_ALL EXP
, PA_COST_DISTRIBUTION_LINES_ALL CDL
, PO_VENDORS VND
, PA_PERIODS_ALL PPA
WHERE EI.COST_DISTRIBUTED_FLAG = 'N'
AND EI.TASK_ID = TT.TASK_ID
AND TT.PROJECT_ID = PP.PROJECT_ID
AND NVL(EXP.INCURRED_BY_PERSON_ID
, 0) = 0
AND EXP.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND ( (EI.SYSTEM_LINKAGE_FUNCTION <> 'PJ'
AND EI.EXPENDITURE_ITEM_DATE BETWEEN PRD.START_DATE
AND PRD.END_DATE) OR ( EI.SYSTEM_LINKAGE_FUNCTION = 'PJ'
AND NVL(EI.PRVDR_ACCRUAL_DATE
, EI.EXPENDITURE_ITEM_DATE) BETWEEN PRD.START_DATE
AND PRD.END_DATE) )
AND PRD.APPLICATION_ID = 8721
AND PRD.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID
AND PRD.ADJUSTMENT_PERIOD_FLAG = 'N'
AND NVL(EI.ORG_ID
, -99) =IMP.ORG_ID
AND CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID(+)
AND CDL.LINE_TYPE = 'R'
AND EI.TRANSACTION_SOURCE IN ('AP EXPENSE'
, 'AP INVOICE')
AND EI.SYSTEM_LINKAGE_FUNCTION IN ('VI'
, 'ER')
AND CDL.SYSTEM_REFERENCE1 IS NOT NULL
AND CDL.SYSTEM_REFERENCE1 = VND.VENDOR_ID
AND EI.EXPENDITURE_ITEM_DATE BETWEEN PPA.START_DATE
AND PPA.END_DATE
AND PPA.ORG_ID = IMP.ORG_ID UNION SELECT PP.PROJECT_ID
, PP.NAME
, EI.TASK_ID TASK_ID
, TT.TASK_NAME
, EI.EXPENDITURE_ID EXPENDITURE_ID
, EI.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, EI.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EI.EXPENDITURE_TYPE EXPENDITURE_TYPE
, NVL(EI.ORGANIZATION_ID
, EI.OVERRIDE_TO_ORGANIZATION_ID)
, PA_EXPENDITURES_UTILS.GETORGTLNAME(NVL(EI.ORGANIZATION_ID
, EI.OVERRIDE_TO_ORGANIZATION_ID))
, PRD.PERIOD_NAME PERIOD_NAME
, PPA.PERIOD_NAME PA_PERIOD_NAME
, DECODE(EI.COST_DIST_REJECTION_CODE
, NULL
, 'NO_COST_DIST'
, EI.COST_DIST_REJECTION_CODE) EXCEPTION_CODE
, EI.QUANTITY QUANTITY
, EI.DENOM_CURRENCY_CODE
, EI.DENOM_RAW_COST
, EI.DENOM_BURDENED_COST
, EI.ACCT_CURRENCY_CODE
, EI.ACCT_RAW_COST
, EI.ACCT_BURDENED_COST
, EI.PROJECT_CURRENCY_CODE
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP'
, 'NO_COST_DIST'
, NULL
, 'R') EXCEPTION_REASON
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP'
, 'NO_COST_DIST'
, NULL
, 'A') CORRECTIVE_ACTION
, EI.ORG_ID ORG_ID
, IMP.SAME_PA_GL_PERIOD
, PA_EXPENDITURES_UTILS.GETORGTLNAME(EI.ORG_ID)
, IMP.SET_OF_BOOKS_ID
, NULL PERSON_NAME
, EXP.INCURRED_BY_PERSON_ID PERSON_ID
, EXP.EXPENDITURE_GROUP EXPENDITURE_BATCH
, NULL VENDOR_ID
, NULL VENDOR_NAME
, NULL VENDOR_NUMBER
, EI.SYSTEM_LINKAGE_FUNCTION
, EI.PRVDR_ACCRUAL_DATE
FROM PA_EXPENDITURE_ITEMS_ALL EI
, PA_IMPLEMENTATIONS_ALL IMP
, GL_PERIOD_STATUSES PRD
, PA_PROJECTS_ALL PP
, PA_TASKS TT
, PA_EXPENDITURES_ALL EXP
, PA_PERIODS_ALL PPA
WHERE EI.COST_DISTRIBUTED_FLAG = 'N'
AND EI.TASK_ID = TT.TASK_ID
AND TT.PROJECT_ID = PP.PROJECT_ID
AND EXP.INCURRED_BY_PERSON_ID IS NULL
AND EXP.EXPENDITURE_ID(+) = EI.EXPENDITURE_ID
AND ( (EI.SYSTEM_LINKAGE_FUNCTION <> 'PJ'
AND EI.EXPENDITURE_ITEM_DATE BETWEEN PRD.START_DATE
AND PRD.END_DATE) OR ( EI.SYSTEM_LINKAGE_FUNCTION = 'PJ'
AND NVL(EI.PRVDR_ACCRUAL_DATE
, EI.EXPENDITURE_ITEM_DATE) BETWEEN PRD.START_DATE
AND PRD.END_DATE) )
AND PRD.APPLICATION_ID = 8721
AND PRD.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID
AND PRD.ADJUSTMENT_PERIOD_FLAG = 'N'
AND NVL(EI.ORG_ID
, -99) =IMP.ORG_ID
AND ((EI.SYSTEM_LINKAGE_FUNCTION NOT IN ('VI'
, 'ER')) OR (NOT EXISTS (SELECT 1
FROM PA_COST_DISTRIBUTION_LINES_ALL CDL
WHERE CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
AND CDL.LINE_TYPE = 'R'
AND CDL.SYSTEM_REFERENCE1 IS NOT NULL)))
AND EI.EXPENDITURE_ITEM_DATE BETWEEN PPA.START_DATE
AND PPA.END_DATE
AND PPA.ORG_ID = IMP.ORG_ID