VIEW: APPS.PO_REQ_DISTRIBUTIONS_INQ_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')