Product: | PO - Purchasing |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.PO_DISTRIBUTIONS_V |
SELECT POD1.ROWID
, POD1.PO_DISTRIBUTION_ID
, POD1.REQ_DISTRIBUTION_ID
, DECODE(POD1.REQ_DISTRIBUTION_ID
, NULL
, 'N'
, 'Y')
, POD1.RATE_DATE
, POD1.AMOUNT_BILLED
, POD1.ENCUMBERED_AMOUNT
, POD1.FAILED_FUNDS_LOOKUP_CODE
, POD1.GL_ENCUMBERED_PERIOD_NAME
, POD1.DESTINATION_ORGANIZATION_ID
, POD1.WIP_ENTITY_ID
, POD1.WIP_RESOURCE_SEQ_NUM
, POD1.BOM_RESOURCE_ID
, POD1.VARIANCE_ACCOUNT_ID
, POD1.DESTINATION_CONTEXT
, POD1.PROGRAM_APPLICATION_ID
, POD1.GOVERNMENT_CONTEXT
, POD1.USSGL_TRANSACTION_CODE
, POD1.WIP_LINE_ID
, POD1.PROJECT_ID
, POD1.TASK_ID
, POD1.EXPENDITURE_TYPE
, POD1.PROJECT_ACCOUNTING_CONTEXT
, POD1.EXPENDITURE_ORGANIZATION_ID
, POD1.GL_CLOSED_DATE
, POD1.ACCRUE_ON_RECEIPT_FLAG
, POD1.EXPENDITURE_ITEM_DATE
, POD1.LAST_UPDATED_BY
, POD1.LINE_LOCATION_ID
, POD1.QUANTITY_ORDERED
, POD1.CREATION_DATE
, NVL(POD1.QUANTITY_DELIVERED
, 0)
, POD1.QUANTITY_CANCELLED
, POD1.LAST_UPDATE_DATE
, POD1.PO_HEADER_ID
, POD1.PO_LINE_ID
, POD1.SET_OF_BOOKS_ID
, POD1.CODE_COMBINATION_ID
, POD1.LAST_UPDATE_LOGIN
, POD1.CREATED_BY
, POD1.PO_RELEASE_ID
, NVL(POD1.QUANTITY_BILLED
, 0)
, DECODE(POD1.REQ_DISTRIBUTION_ID
, NULL
, POD1.REQ_HEADER_REFERENCE_NUM
, PORH.SEGMENT1)
, DECODE(POD1.REQ_DISTRIBUTION_ID
, NULL
, POD1.REQ_LINE_REFERENCE_NUM
, PORL.LINE_NUM)
, POD1.DELIVER_TO_LOCATION_ID
, POD1.DELIVER_TO_PERSON_ID
, POD1.RATE
, POD1.ACCRUED_FLAG
, POD1.ENCUMBERED_FLAG
, POD1.UNENCUMBERED_QUANTITY
, POD1.UNENCUMBERED_AMOUNT
, POD1.GL_ENCUMBERED_DATE
, POD1.GL_CANCELLED_DATE
, POD1.DESTINATION_TYPE_CODE
, POD1.DESTINATION_SUBINVENTORY
, POD1.ATTRIBUTE_CATEGORY
, POD1.ATTRIBUTE1
, POD1.ATTRIBUTE2
, POD1.ATTRIBUTE3
, POD1.ATTRIBUTE4
, POD1.ATTRIBUTE5
, POD1.ATTRIBUTE6
, POD1.ATTRIBUTE7
, POD1.ATTRIBUTE8
, POD1.ATTRIBUTE9
, POD1.ATTRIBUTE10
, POD1.ATTRIBUTE11
, POD1.ATTRIBUTE12
, POD1.ATTRIBUTE13
, POD1.ATTRIBUTE14
, POD1.ATTRIBUTE15
, POD1.WIP_OPERATION_SEQ_NUM
, POD1.WIP_REPETITIVE_SCHEDULE_ID
, POD1.BUDGET_ACCOUNT_ID
, POD1.ACCRUAL_ACCOUNT_ID
, POD2.DISTRIBUTION_NUM
, POD1.SOURCE_DISTRIBUTION_ID
, POD1.DISTRIBUTION_NUM
, POD1.REQUEST_ID
, POD1.PROGRAM_ID
, POD1.PROGRAM_UPDATE_DATE
, POD1.PREVENT_ENCUMBRANCE_FLAG
, PORL.REQUISITION_LINE_ID
, PORH.REQUISITION_HEADER_ID
, PORL.LINE_NUM
, PORH.SEGMENT1
, POD1.END_ITEM_UNIT_NUMBER
, POD1.RECOVERABLE_TAX
, POD1.NONRECOVERABLE_TAX
, POD1.RECOVERY_RATE
, POD1.TAX_RECOVERY_OVERRIDE_FLAG
, POD1.AWARD_ID
, POD1.OKE_CONTRACT_LINE_ID
, POD1.OKE_CONTRACT_DELIVERABLE_ID
, POD1.AMOUNT_ORDERED
, POD1.AMOUNT_DELIVERED
, POD1.AMOUNT_CANCELLED
, POD1.INVOICE_ADJUSTMENT_FLAG
, POD1.AMOUNT_TO_ENCUMBER
, POD1.DISTRIBUTION_TYPE
, POD1.DEST_CHARGE_ACCOUNT_ID
, POD1.DEST_VARIANCE_ACCOUNT_ID
, PORH.ORG_ID
, HOUT.NAME
FROM PO_DISTRIBUTIONS_ALL POD2
, PO_REQUISITION_HEADERS_ALL PORH
, PO_REQUISITION_LINES_ALL PORL
, PO_REQ_DISTRIBUTIONS_ALL PORD
, PO_DISTRIBUTIONS POD1
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
WHERE POD1.SOURCE_DISTRIBUTION_ID = POD2.PO_DISTRIBUTION_ID (+)
AND POD1.REQ_DISTRIBUTION_ID = PORD.DISTRIBUTION_ID (+)
AND PORD.REQUISITION_LINE_ID = PORL.REQUISITION_LINE_ID (+)
AND PORL.REQUISITION_HEADER_ID = PORH.REQUISITION_HEADER_ID (+)
AND PORH.ORG_ID = HOUT.ORGANIZATION_ID (+)
AND HOUT.LANGUAGE (+) = USERENV('LANG')