View: PO_DISTRIBUTIONS_INQ_V

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

View Text

SELECT POD.ROWID
, POD.AMOUNT_BILLED
, POD.DESTINATION_CONTEXT
, POD.DESTINATION_SUBINVENTORY
, POD.DISTRIBUTION_NUM
, POD.ENCUMBERED_AMOUNT
, POD.EXPENDITURE_ITEM_DATE
, POD.EXPENDITURE_TYPE
, POD.GL_CANCELLED_DATE
, POD.GL_CLOSED_DATE
, POD.GL_ENCUMBERED_DATE
, POD.GL_ENCUMBERED_PERIOD_NAME
, POD.GOVERNMENT_CONTEXT
, POD.PROJECT_ACCOUNTING_CONTEXT
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, TO_NUMBER(NULL)
, 'FIXED PRICE'
, TO_NUMBER(NULL)
, POD.QUANTITY_BILLED)
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, TO_NUMBER(NULL)
, 'FIXED PRICE'
, TO_NUMBER(NULL)
, POD.QUANTITY_CANCELLED)
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, TO_NUMBER(NULL)
, 'FIXED PRICE'
, TO_NUMBER(NULL)
, POD.QUANTITY_DELIVERED)
, POD.QUANTITY_ORDERED
, POD.RATE
, POD.RATE_DATE
, POD.REQ_HEADER_REFERENCE_NUM
, POD.REQ_LINE_REFERENCE_NUM
, POD.UNENCUMBERED_AMOUNT
, POD.UNENCUMBERED_QUANTITY
, POD.WIP_OPERATION_SEQ_NUM
, POD.WIP_RESOURCE_SEQ_NUM
, POD.ACCRUAL_ACCOUNT_ID
, POD.BOM_RESOURCE_ID
, POD.BUDGET_ACCOUNT_ID
, POD.CODE_COMBINATION_ID
, POD.DELIVER_TO_LOCATION_ID
, POD.DELIVER_TO_PERSON_ID
, POD.DESTINATION_ORGANIZATION_ID
, POD.EXPENDITURE_ORGANIZATION_ID
, POD.LINE_LOCATION_ID
, POD.PO_DISTRIBUTION_ID
, POD.PO_HEADER_ID
, POD.PO_LINE_ID
, POD.PO_RELEASE_ID
, POD.PROJECT_ID
, POD.REQ_DISTRIBUTION_ID
, POD.SET_OF_BOOKS_ID
, POD.SOURCE_DISTRIBUTION_ID
, POD.TASK_ID
, POD.VARIANCE_ACCOUNT_ID
, POD.WIP_ENTITY_ID
, POD.WIP_LINE_ID
, POD.WIP_REPETITIVE_SCHEDULE_ID
, POD.DESTINATION_TYPE_CODE
, POD.FAILED_FUNDS_LOOKUP_CODE
, POD.USSGL_TRANSACTION_CODE
, POD.ACCRUED_FLAG
, POD.ACCRUE_ON_RECEIPT_FLAG
, POD.ENCUMBERED_FLAG
, POD.PREVENT_ENCUMBRANCE_FLAG
, POD.CREATED_BY
, POD.CREATION_DATE
, POD.LAST_UPDATED_BY
, POD.LAST_UPDATE_DATE
, POD.LAST_UPDATE_LOGIN
, POD.PROGRAM_APPLICATION_ID
, POD.PROGRAM_ID
, POD.PROGRAM_UPDATE_DATE
, POD.REQUEST_ID
, POD.ATTRIBUTE_CATEGORY
, POD.ATTRIBUTE1
, POD.ATTRIBUTE2
, POD.ATTRIBUTE3
, POD.ATTRIBUTE4
, POD.ATTRIBUTE5
, POD.ATTRIBUTE6
, POD.ATTRIBUTE7
, POD.ATTRIBUTE8
, POD.ATTRIBUTE9
, POD.ATTRIBUTE10
, POD.ATTRIBUTE11
, POD.ATTRIBUTE12
, POD.ATTRIBUTE13
, POD.ATTRIBUTE14
, POD.ATTRIBUTE15
, PORD.DISTRIBUTION_NUM
, DECODE(POD.REQ_DISTRIBUTION_ID
, NULL
, 'N'
, 'Y')
, DECODE(POD.REQ_DISTRIBUTION_ID
, NULL
, POD.REQ_LINE_REFERENCE_NUM
, PORL.LINE_NUM)
, PORH.REQUISITION_HEADER_ID
, DECODE(POD.REQ_DISTRIBUTION_ID
, NULL
, POD.REQ_HEADER_REFERENCE_NUM
, PORH.SEGMENT1)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, POH.SEGMENT1
, POH.TYPE_LOOKUP_CODE
, POR.RELEASE_NUM
, POR.RELEASE_TYPE
, DECODE(POD.PO_RELEASE_ID
, NULL
, DECODE(POH.AGENT_ID
, NULL
, TO_NUMBER(NULL)
, POH.AGENT_ID)
, POR.AGENT_ID)
, POH.VENDOR_ID
, NULL
, POH.VENDOR_SITE_ID
, NULL
, POH.BILL_TO_LOCATION_ID
, NULL
, POH.CURRENCY_CODE
, DECODE(PLL.PO_RELEASE_ID
, NULL
, NVL(POH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
, NVL(POR.AUTHORIZATION_STATUS
, 'INCOMPLETE'))
, DECODE(PLL.PO_RELEASE_ID
, NULL
, DECODE(POH.REVISION_NUM
, NULL
, TO_NUMBER(NULL)
, POH.REVISION_NUM)
, POR.REVISION_NUM)
, DECODE(PLL.PO_RELEASE_ID
, NULL
, PDTL.TYPE_NAME
, PDTL2.TYPE_NAME)
, NULL
, DECODE(PLL.PO_RELEASE_ID
, NULL
, DECODE(POH.CREATION_DATE
, NULL
, TO_DATE(NULL)
, POH.CREATION_DATE)
, POR.CREATION_DATE)
, DECODE(PLL.PO_RELEASE_ID
, NULL
, DECODE(POH.APPROVED_DATE
, NULL
, TO_DATE(NULL)
, POH.APPROVED_DATE)
, POR.APPROVED_DATE)
, DECODE(PLL.PO_RELEASE_ID
, NULL
, DECODE(POH.REVISED_DATE
, NULL
, NULL
, POH.REVISED_DATE)
, POR.REVISED_DATE)
, NULL
, POH.ACCEPTANCE_DUE_DATE
, POL.LINE_NUM
, POL.LINE_TYPE_ID
, PLTT.LINE_TYPE
, POL.ITEM_ID
, POL.ITEM_REVISION
, POL.ITEM_DESCRIPTION
, POL.CATEGORY_ID
, POL.CONTRACT_NUM
, POL.UNIT_MEAS_LOOKUP_CODE
, POL.VENDOR_PRODUCT_NUM
, PLL.SHIPMENT_NUM
, NULL
, PLL.NEED_BY_DATE
, PLL.PRICE_OVERRIDE
, PLL.TAXABLE_FLAG
, NULL
, PLL.SHIPMENT_TYPE
, NULL
, NVL(PLL.CLOSED_CODE
, 'OPEN')
, NULL
, PLL.CLOSED_DATE
, PLL.CLOSED_BY
, DECODE (PLL.RECEIPT_REQUIRED_FLAG
, 'N'
, DECODE (PLL.INSPECTION_REQUIRED_FLAG
, 'N'
, '2-WAY'
, NULL)
, 'Y'
, DECODE (PLL.INSPECTION_REQUIRED_FLAG
, 'N'
, '3-WAY'
, 'Y'
, '4-WAY'
, NULL))
, POD.END_ITEM_UNIT_NUMBER
, POD.RECOVERY_RATE
, POD.OKE_CONTRACT_LINE_ID
, POD.OKE_CONTRACT_DELIVERABLE_ID
, PLL.VMI_FLAG
, DECODE(POD.PO_RELEASE_ID
, NULL
, POH.CONSIGNED_CONSUMPTION_FLAG
, POR.CONSIGNED_CONSUMPTION_FLAG)
, PLL.CONSIGNED_FLAG
, POL.CONTRACT_ID
, POD.AMOUNT_ORDERED
, POD.AMOUNT_DELIVERED
, POD.AMOUNT_CANCELLED
, POD.INVOICE_ADJUSTMENT_FLAG
, POD.AWARD_ID
, PORH.ORG_ID
, POH.ORG_ID
, POH.ORG_ID
, POD.DEST_CHARGE_ACCOUNT_ID
, POD.DEST_VARIANCE_ACCOUNT_ID
, PDT.SECURITY_LEVEL_CODE
FROM PO_DOCUMENT_TYPES_ALL_B PDT
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, PO_DOCUMENT_TYPES_ALL_B PDTB2
, PO_DOCUMENT_TYPES_ALL_TL PDTL2
, PO_LINE_TYPES_TL PLTT
, PO_REQ_DISTRIBUTIONS_ALL PORD
, PO_REQUISITION_LINES_ALL PORL
, PO_REQUISITION_HEADERS_ALL PORH
, PO_RELEASES_ALL POR
, PO_HEADERS_ALL POH
, PO_LINE_LOCATIONS_ALL PLL
, PO_LINES_ALL POL
, PO_DISTRIBUTIONS_ALL POD
WHERE POD.PO_HEADER_ID = POH.PO_HEADER_ID
AND POD.PO_LINE_ID = POL.PO_LINE_ID (+)
AND POD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID (+)
AND POD.PO_RELEASE_ID = POR.PO_RELEASE_ID (+)
AND POD.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 PDT.DOCUMENT_TYPE_CODE IN ('PO'
, 'PA')
AND PDT.ORG_ID = POH.ORG_ID
AND PDT.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE
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(+) = POD.ORG_ID
AND PDTL.ORG_ID(+) = POD.ORG_ID
AND PDTL.ORG_ID = PDT.ORG_ID
AND PDTB2.DOCUMENT_TYPE_CODE(+) = 'RELEASE'
AND PDTB2.DOCUMENT_SUBTYPE(+) = POR.RELEASE_TYPE
AND PDTB2.ORG_ID(+) = POR.ORG_ID
AND PDTB2.DOCUMENT_TYPE_CODE = PDTL2.DOCUMENT_TYPE_CODE(+)
AND PDTB2.DOCUMENT_SUBTYPE = PDTL2.DOCUMENT_SUBTYPE(+)
AND PDTB2.ORG_ID = PDTL2.ORG_ID(+)
AND PDTL2.LANGUAGE(+) = USERENV('LANG')
AND NVL(PLL.SHIPMENT_TYPE
, 'AGREEMENT') != 'PRICE BREAK'
AND PLTT.LINE_TYPE_ID (+) = POL.LINE_TYPE_ID
AND PLTT.LANGUAGE(+) = USERENV('LANG')

Columns