View: PO_REQ_DISTRIBUTIONS_INQ_V

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PO_REQ_DISTRIBUTIONS_INQ_V

View Text

SELECT PRD.ROWID
, PRD.DISTRIBUTION_ID
, PRD.LAST_UPDATE_DATE
, PRD.LAST_UPDATED_BY
, PRD.REQUISITION_LINE_ID
, PRD.SET_OF_BOOKS_ID
, PRD.CODE_COMBINATION_ID
, PRD.REQ_LINE_QUANTITY
, PRD.LAST_UPDATE_LOGIN
, PRD.CREATION_DATE
, PRD.CREATED_BY
, NVL(PRD.ENCUMBERED_FLAG
, 'N')
, PRD.GL_ENCUMBERED_DATE
, PRD.GL_ENCUMBERED_PERIOD_NAME
, PRD.GL_CANCELLED_DATE
, PRD.FAILED_FUNDS_LOOKUP_CODE
, PRD.ENCUMBERED_AMOUNT
, PRD.BUDGET_ACCOUNT_ID
, PRD.ACCRUAL_ACCOUNT_ID
, PRD.VARIANCE_ACCOUNT_ID
, 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.USSGL_TRANSACTION_CODE
, PRD.GOVERNMENT_CONTEXT
, PRD.REQUEST_ID
, PRD.PROGRAM_APPLICATION_ID
, PRD.PROGRAM_ID
, PRD.PROGRAM_UPDATE_DATE
, PRD.PROJECT_ID
, PRD.TASK_ID
, PRD.EXPENDITURE_TYPE
, PRD.PROJECT_ACCOUNTING_CONTEXT
, PRD.EXPENDITURE_ORGANIZATION_ID
, PRD.GL_CLOSED_DATE
, PRD.SOURCE_REQ_DISTRIBUTION_ID
, PRD.DISTRIBUTION_NUM
, PRD.PROJECT_RELATED_FLAG
, PRD.EXPENDITURE_ITEM_DATE
, PRL.LINE_NUM
, PLT.LINE_TYPE
, PLT.LINE_TYPE_ID
, PRL.LINE_LOCATION_ID
, PRL.ITEM_ID
, PRL.ITEM_REVISION
, PRL.CATEGORY_ID
, PRL.ITEM_DESCRIPTION
, PRL.UNIT_MEAS_LOOKUP_CODE
, PRL.SUGGESTED_VENDOR_PRODUCT_CODE
, PRL.CREATION_DATE
, PRL.NEED_BY_DATE
, PRL.CLOSED_CODE
, PRL.CLOSED_DATE
, PRL.CANCEL_FLAG
, PRL.CANCEL_DATE
, PRL.MODIFIED_BY_AGENT_FLAG
, PRL.PARENT_REQ_LINE_ID
, PRL.PURCHASING_AGENT_ID
, PRL.REFERENCE_NUM
, PRL.TO_PERSON_ID
, PRL.SUGGESTED_BUYER_ID
, PRL.DESTINATION_TYPE_CODE
, PRL.DESTINATION_ORGANIZATION_ID
, HOUT3.NAME
, PRL.DELIVER_TO_LOCATION_ID
, HRL1.LOCATION_CODE
, PRL.DESTINATION_SUBINVENTORY
, PRL.SOURCE_TYPE_CODE
, PRL.SUGGESTED_VENDOR_NAME
, PRL.SUGGESTED_VENDOR_LOCATION
, PRL.CURRENCY_CODE
, PRL.SOURCE_ORGANIZATION_ID
, HOUT.NAME
, PRL.SOURCE_SUBINVENTORY
, PRL.DOCUMENT_TYPE_CODE
, PRL.BLANKET_PO_HEADER_ID
, PRL.BLANKET_PO_LINE_NUM
, PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1
, PRH.PREPARER_ID
, PRH.AUTHORIZATION_STATUS
, PLC_STTS.DISPLAYED_FIELD
, PRH.TYPE_LOOKUP_CODE
, PDTL.TYPE_NAME
, PLC_DEST.DISPLAYED_FIELD
, PLC_STYPE.DISPLAYED_FIELD
, PLC_SDOC.DISPLAYED_FIELD
, MUOM.UOM_CLASS
, PRH.INTERFACE_SOURCE_CODE
, PRL.UNIT_PRICE
, PAP.SEGMENT1
, PAT.TASK_NUMBER
, HOUT2.NAME
, PRD.END_ITEM_UNIT_NUMBER
, PRD.RECOVERY_RATE
, PRD.OKE_CONTRACT_LINE_ID
, PRD.OKE_CONTRACT_DELIVERABLE_ID
, PRL.VMI_FLAG
, PRD.REQ_LINE_AMOUNT
, PRD.REQ_LINE_CURRENCY_AMOUNT
, PRH.CONTRACTOR_REQUISITION_FLAG
, PRD.AWARD_ID
, PRL.ORG_ID
, PDT.SECURITY_LEVEL_CODE
FROM PO_LINE_TYPES PLT
, PO_DOCUMENT_TYPES_ALL_B PDT
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, PO_UN_NUMBERS POUN
, PO_LOOKUP_CODES PLC_STTS
, PO_LOOKUP_CODES PLC_TRSN
, PO_LOOKUP_CODES PLC_SDOC
, PO_LOOKUP_CODES PLC_STYPE
, PO_LOOKUP_CODES PLC_DEST
, HR_LOCATIONS_ALL_TL HRL1
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
, HR_ALL_ORGANIZATION_UNITS_TL HOUT2
, HR_ALL_ORGANIZATION_UNITS_TL HOUT3
, MTL_UNITS_OF_MEASURE MUOM
, PO_HAZARD_CLASSES PHC
, PO_LOCATION_ASSOCIATIONS_ALL POLA
, GL_DAILY_CONVERSION_TYPES GDT
, PA_TASKS PAT
, PA_PROJECTS_ALL PAP
, PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES_ALL PRL
, PO_REQ_DISTRIBUTIONS_ALL PRD
WHERE PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND PLT.LINE_TYPE_ID = PRL.LINE_TYPE_ID
AND POUN.UN_NUMBER_ID (+) = PRL.UN_NUMBER_ID
AND PHC.HAZARD_CLASS_ID (+) = PRL.HAZARD_CLASS_ID
AND HRL1.LOCATION_ID(+) = PRL.DELIVER_TO_LOCATION_ID
AND HRL1.LANGUAGE (+) = USERENV('LANG')
AND MUOM.UNIT_OF_MEASURE (+)= PRL.UNIT_MEAS_LOOKUP_CODE
AND POLA.LOCATION_ID (+) = PRL.DELIVER_TO_LOCATION_ID
AND POLA.ORG_ID(+) = PRL.ORG_ID
AND GDT.CONVERSION_TYPE (+) = PRL.RATE_TYPE
AND PAP.PROJECT_ID (+) = PRD.PROJECT_ID
AND PAP.ORG_ID (+) = PRD.ORG_ID
AND PAT.TASK_ID (+) = PRD.TASK_ID
AND PDT.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE
AND PDT.DOCUMENT_TYPE_CODE = 'REQUISITION'|| DECODE(PRD.ROWID
, NULL
, ''
, '')
AND PDTL.DOCUMENT_TYPE_CODE = PDT.DOCUMENT_TYPE_CODE
AND PDTL.DOCUMENT_SUBTYPE = PDT.DOCUMENT_SUBTYPE
AND PDTL.LANGUAGE = USERENV('LANG')
AND PDT.ORG_ID(+) = PRD.ORG_ID
AND PDTL.ORG_ID(+) = PRD.ORG_ID
AND PLC_STTS.LOOKUP_CODE = NVL(PRH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
AND PLC_STTS.LOOKUP_TYPE = 'AUTHORIZATION STATUS'|| DECODE(PRD.ROWID
, NULL
, ''
, '')
AND PLC_TRSN.LOOKUP_TYPE (+) = 'TRANSACTION_REASON'
AND PLC_TRSN.LOOKUP_CODE (+) = PRL.TRANSACTION_REASON_CODE
AND PLC_SDOC.LOOKUP_TYPE (+) = 'SOURCE DOCUMENT TYPE'
AND PLC_SDOC.LOOKUP_CODE (+) = PRL.DOCUMENT_TYPE_CODE
AND PLC_STYPE.LOOKUP_TYPE (+) = 'REQUISITION SOURCE TYPE'
AND PLC_STYPE.LOOKUP_CODE (+) = PRL.SOURCE_TYPE_CODE
AND PLC_DEST.LOOKUP_TYPE (+) = 'DESTINATION TYPE'
AND PLC_DEST.LOOKUP_CODE (+) = PRL.DESTINATION_TYPE_CODE
AND HOUT.ORGANIZATION_ID(+) = PRL.SOURCE_ORGANIZATION_ID
AND HOUT.LANGUAGE(+) = USERENV('LANG')
AND HOUT2.ORGANIZATION_ID(+) = PRD.EXPENDITURE_ORGANIZATION_ID
AND HOUT2.LANGUAGE(+) = USERENV('LANG')
AND HOUT3.ORGANIZATION_ID(+) = PRL.DESTINATION_ORGANIZATION_ID
AND HOUT3.LANGUAGE(+) = USERENV('LANG')

Columns