VIEW: APPS.PO_REQ_DISTS_REF_V

Source

View Text - Preformatted

SELECT PRD.DISTRIBUTION_ID , PRD.DISTRIBUTION_NUM , 'REQUISITION' , PRD.GL_ENCUMBERED_DATE , PRD.CODE_COMBINATION_ID , PRD.BUDGET_ACCOUNT_ID , PRD.BUDGET_ACCOUNT_ID, PRD.SOURCE_REQ_DISTRIBUTION_ID, NVL(PRD.ENCUMBERED_FLAG, 'N'), PRD.PROJECT_ID , PP.NAME , PRD.TASK_ID , PT.TASK_NAME , PRD.EXPENDITURE_ORGANIZATION_ID, HOU.NAME , PRD.EXPENDITURE_TYPE , PRD.AWARD_ID , GA.AWARD_NUMBER , PRD.PREVENT_ENCUMBRANCE_FLAG, PRD.ATTRIBUTE_CATEGORY, PRD.ATTRIBUTE1 , PRD.ATTRIBUTE2 , PRD.ATTRIBUTE3 , PRD.ATTRIBUTE4 , PRD.ATTRIBUTE5 , PRD.ATTRIBUTE6 , PRD.ATTRIBUTE7 , PRD.ATTRIBUTE8 , PRD.ATTRIBUTE9 , PRD.ATTRIBUTE10 , PRD.ATTRIBUTE11 , PRD.ATTRIBUTE12 , PRD.ATTRIBUTE13 , PRD.ATTRIBUTE14 , PRD.ATTRIBUTE15 , PRD.ORG_ID , HOU.NAME , PRD.SET_OF_BOOKS_ID , GLSOB.CURRENCY_CODE , PRL.QUANTITY , PRL.UNIT_PRICE , PRD.REQ_LINE_AMOUNT, PRD.REQ_LINE_CURRENCY_AMOUNT FROM PO_REQUISITION_LINES_ALL PRL, PO_REQ_DISTRIBUTIONS_ALL PRD, PO_LINE_TYPES PLT, PO_SYSTEM_PARAMETERS_ALL PSP, PA_PROJECTS_ALL PP, PA_TASKS PT, GMS_AWARDS_ALL GA, HR_ALL_ORGANIZATION_UNITS_TL HOU, WIP_ENTITIES WE, GL_SETS_OF_BOOKS GLSOB WHERE PRD.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID AND PRL.LINE_TYPE_ID = PLT.LINE_TYPE_ID AND PRD.ORG_ID = PSP.ORG_ID AND PRD.PROJECT_ID = PP.PROJECT_ID(+) AND PRD.TASK_ID = PT.TASK_ID(+) AND PRD.AWARD_ID = GA.AWARD_ID(+) AND PRD.ORG_ID = HOU.ORGANIZATION_ID AND HOU.LANGUAGE = USERENV('LANG') AND PRL.WIP_ENTITY_ID = WE.WIP_ENTITY_ID(+) AND PRD.SET_OF_BOOKS_ID = GLSOB.SET_OF_BOOKS_ID AND EXISTS( SELECT 'exists' FROM per_all_people_f he WHERE PRL.TO_PERSON_ID = He.PERSON_ID AND Trunc(SYSDATE) BETWEEN he.effective_start_date AND he.effective_end_date )

View Text - HTML Formatted

SELECT PRD.DISTRIBUTION_ID
, PRD.DISTRIBUTION_NUM
, 'REQUISITION'
, PRD.GL_ENCUMBERED_DATE
, PRD.CODE_COMBINATION_ID
, PRD.BUDGET_ACCOUNT_ID
, PRD.BUDGET_ACCOUNT_ID
, PRD.SOURCE_REQ_DISTRIBUTION_ID
, NVL(PRD.ENCUMBERED_FLAG
, 'N')
, PRD.PROJECT_ID
, PP.NAME
, PRD.TASK_ID
, PT.TASK_NAME
, PRD.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, PRD.EXPENDITURE_TYPE
, PRD.AWARD_ID
, GA.AWARD_NUMBER
, PRD.PREVENT_ENCUMBRANCE_FLAG
, PRD.ATTRIBUTE_CATEGORY
, PRD.ATTRIBUTE1
, PRD.ATTRIBUTE2
, PRD.ATTRIBUTE3
, PRD.ATTRIBUTE4
, PRD.ATTRIBUTE5
, PRD.ATTRIBUTE6
, PRD.ATTRIBUTE7
, PRD.ATTRIBUTE8
, PRD.ATTRIBUTE9
, PRD.ATTRIBUTE10
, PRD.ATTRIBUTE11
, PRD.ATTRIBUTE12
, PRD.ATTRIBUTE13
, PRD.ATTRIBUTE14
, PRD.ATTRIBUTE15
, PRD.ORG_ID
, HOU.NAME
, PRD.SET_OF_BOOKS_ID
, GLSOB.CURRENCY_CODE
, PRL.QUANTITY
, PRL.UNIT_PRICE
, PRD.REQ_LINE_AMOUNT
, PRD.REQ_LINE_CURRENCY_AMOUNT
FROM PO_REQUISITION_LINES_ALL PRL
, PO_REQ_DISTRIBUTIONS_ALL PRD
, PO_LINE_TYPES PLT
, PO_SYSTEM_PARAMETERS_ALL PSP
, PA_PROJECTS_ALL PP
, PA_TASKS PT
, GMS_AWARDS_ALL GA
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, WIP_ENTITIES WE
, GL_SETS_OF_BOOKS GLSOB
WHERE PRD.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID
AND PRL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND PRD.ORG_ID = PSP.ORG_ID
AND PRD.PROJECT_ID = PP.PROJECT_ID(+)
AND PRD.TASK_ID = PT.TASK_ID(+)
AND PRD.AWARD_ID = GA.AWARD_ID(+)
AND PRD.ORG_ID = HOU.ORGANIZATION_ID
AND HOU.LANGUAGE = USERENV('LANG')
AND PRL.WIP_ENTITY_ID = WE.WIP_ENTITY_ID(+)
AND PRD.SET_OF_BOOKS_ID = GLSOB.SET_OF_BOOKS_ID
AND EXISTS( SELECT 'EXISTS'
FROM PER_ALL_PEOPLE_F HE
WHERE PRL.TO_PERSON_ID = HE.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN HE.EFFECTIVE_START_DATE
AND HE.EFFECTIVE_END_DATE )