eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PO_DISTRIBUTIONS_INQ_V

Source

View Text - Preformatted


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 , WP.WIP_ENTITY_NAME , NULL , NULL , NULL , POH.SEGMENT1 , POH.TYPE_LOOKUP_CODE , NULL , NULL , POH.AGENT_ID , POH.VENDOR_ID , NULL , POH.VENDOR_SITE_ID , NULL , POH.BILL_TO_LOCATION_ID , NULL , POH.CURRENCY_CODE , POH.AUTHORIZATION_STATUS , POH.REVISION_NUM , PDTL.TYPE_NAME , NULL , POH.CREATION_DATE , POH.APPROVED_DATE , POH.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(NVL(PLL.RECEIPT_REQUIRED_FLAG,'N'), 'N', '2-Way', 'Y', DECODE(PLL.INSPECTION_REQUIRED_FLAG, 'Y', '4-Way', '3-Way')) , POD.END_ITEM_UNIT_NUMBER , POD.RECOVERY_RATE , POD.OKE_CONTRACT_LINE_ID , POD.OKE_CONTRACT_DELIVERABLE_ID , PLL.VMI_FLAG , POH.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, POH.STYLE_ID FROM PO_DOCUMENT_TYPES_ALL_B PDT, PO_DOCUMENT_TYPES_ALL_TL PDTL, PO_LINE_TYPES_TL PLTT, PO_REQ_DISTRIBUTIONS_ALL PORD, PO_REQUISITION_LINES_ALL PORL, PO_REQUISITION_HEADERS_ALL PORH, PO_HEADERS_ALL POH, PO_LINE_LOCATIONS_ALL PLL, PO_LINES_ALL POL, PO_DISTRIBUTIONS_ALL POD, PO_DOC_STYLE_HEADERS PDSH, WIP_ENTITIES WP WHERE POD.PO_HEADER_ID = POH.PO_HEADER_ID AND POD.PO_RELEASE_ID IS NULL AND POD.PO_LINE_ID = POL.PO_LINE_ID AND POD.LINE_LOCATION_ID = PLL.LINE_LOCATION_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.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 NVL(PDT.ORG_ID,-99) = NVL(PDTL.ORG_ID,-99) AND (PDT.ORG_ID IS NULL OR PDT.ORG_ID = POD.ORG_ID) AND (PDTL.ORG_ID IS NULL OR PDTL.ORG_ID = POD.ORG_ID) AND PLL.SHIPMENT_TYPE != 'PRICE BREAK' AND PLTT.LINE_TYPE_ID (+) = POL.LINE_TYPE_ID AND PLTT.LANGUAGE(+) = USERENV('LANG') AND POH.STYLE_ID=PDSH.STYLE_ID AND NVL(PDSH.PROGRESS_PAYMENT_FLAG,'N') = 'N' AND POD.WIP_ENTITY_ID = WP.WIP_ENTITY_ID(+) UNION ALL 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 , WP.WIP_ENTITY_NAME , NULL , NULL , NULL , POH.SEGMENT1 , POH.TYPE_LOOKUP_CODE , POR.RELEASE_NUM , POR.RELEASE_TYPE , POR.AGENT_ID , POH.VENDOR_ID , NULL , POH.VENDOR_SITE_ID , NULL , POH.BILL_TO_LOCATION_ID , NULL , POH.CURRENCY_CODE , POR.AUTHORIZATION_STATUS , POR.REVISION_NUM , PDTL2.TYPE_NAME , NULL , POR.CREATION_DATE , POR.APPROVED_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 (NVL(PLL.RECEIPT_REQUIRED_FLAG,'N'),'N','2-Way','Y',DECODE(PLL.INSPECTION_REQUIRED_FLAG,'Y','4-Way','3-Way')) , POD.END_ITEM_UNIT_NUMBER , POD.RECOVERY_RATE , POD.OKE_CONTRACT_LINE_ID , POD.OKE_CONTRACT_DELIVERABLE_ID , PLL.VMI_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, POH.STYLE_ID 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, PO_DOC_STYLE_HEADERS PDSH, PO_SYSTEM_PARAMETERS PSP, WIP_ENTITIES WP WHERE POD.PO_HEADER_ID = POH.PO_HEADER_ID AND POD.PO_RELEASE_ID = POR.PO_RELEASE_ID AND POD.PO_LINE_ID = POL.PO_LINE_ID AND POD.LINE_LOCATION_ID = PLL.LINE_LOCATION_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.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 NVL(PDT.ORG_ID,-99) = NVL(PDTL.ORG_ID,-99) AND (PDT.ORG_ID IS NULL OR PDT.ORG_ID = POD.ORG_ID) AND (PDTL.ORG_ID IS NULL OR PDTL.ORG_ID = POD.ORG_ID) AND PDTB2.DOCUMENT_TYPE_CODE(+) = 'RELEASE' AND PDTB2.DOCUMENT_SUBTYPE(+) = POR.RELEASE_TYPE AND PDTB2.DOCUMENT_TYPE_CODE = PDTL2.DOCUMENT_TYPE_CODE(+) AND PDTB2.DOCUMENT_SUBTYPE = PDTL2.DOCUMENT_SUBTYPE(+) AND NVL(PDTB2.ORG_ID,-99) = NVL(PDTL2.ORG_ID,-99) AND (PDTB2.ORG_ID IS NULL OR PSP.ORG_ID = PDTB2.ORG_ID) AND PDTL2.LANGUAGE(+) = USERENV('LANG') AND PLTT.LINE_TYPE_ID (+) = POL.LINE_TYPE_ID AND PLTT.LANGUAGE(+) = USERENV('LANG') AND POH.STYLE_ID=PDSH.STYLE_ID AND NVL(PDSH.PROGRESS_PAYMENT_FLAG,'N') = 'N' AND POD.WIP_ENTITY_ID = WP.WIP_ENTITY_ID(+) UNION ALL 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 , POD.QUANTITY_BILLED , POD.QUANTITY_CANCELLED , 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 , NULL , 'N' , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , POH.SEGMENT1 , POH.TYPE_LOOKUP_CODE , NULL , NULL , POH.AGENT_ID , POH.VENDOR_ID , NULL , POH.VENDOR_SITE_ID , NULL , POH.BILL_TO_LOCATION_ID , NULL , POH.CURRENCY_CODE , POH.AUTHORIZATION_STATUS , POH.REVISION_NUM , PDTL.TYPE_NAME , NULL , POH.CREATION_DATE , POH.APPROVED_DATE , POH.REVISED_DATE , NULL , POH.ACCEPTANCE_DUE_DATE , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , 'OPEN' , NULL , NULL , NULL , NULL , POD.END_ITEM_UNIT_NUMBER , POD.RECOVERY_RATE , POD.OKE_CONTRACT_LINE_ID , POD.OKE_CONTRACT_DELIVERABLE_ID , NULL , POH.CONSIGNED_CONSUMPTION_FLAG , NULL , NULL , POD.AMOUNT_ORDERED, POD.AMOUNT_DELIVERED, POD.AMOUNT_CANCELLED, POD.INVOICE_ADJUSTMENT_FLAG, POD.AWARD_ID, NULL, POH.ORG_ID, POH.ORG_ID, POD.DEST_CHARGE_ACCOUNT_ID, POD.DEST_VARIANCE_ACCOUNT_ID, PDT.SECURITY_LEVEL_CODE, POH.STYLE_ID FROM PO_DOCUMENT_TYPES_ALL_B PDT, PO_DOCUMENT_TYPES_ALL_TL PDTL, PO_HEADERS_ALL POH, PO_DISTRIBUTIONS_ALL POD, PO_DOC_STYLE_HEADERS PDSH WHERE POD.PO_HEADER_ID = POH.PO_HEADER_ID AND POH.ENCUMBRANCE_REQUIRED_FLAG = 'Y' AND POD.DISTRIBUTION_TYPE = 'AGREEMENT' AND PDT.DOCUMENT_TYPE_CODE = 'PA' 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 NVL(PDT.ORG_ID,-99) = NVL(PDTL.ORG_ID,-99) AND (PDT.ORG_ID IS NULL OR PDT.ORG_ID = POD.ORG_ID) AND (PDTL.ORG_ID IS NULL OR PDTL.ORG_ID = POD.ORG_ID) AND POH.STYLE_ID=PDSH.STYLE_ID AND NVL(PDSH.PROGRESS_PAYMENT_FLAG,'N') = 'N'

View Text - HTML Formatted

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
, WP.WIP_ENTITY_NAME
, NULL
, NULL
, NULL
, POH.SEGMENT1
, POH.TYPE_LOOKUP_CODE
, NULL
, NULL
, POH.AGENT_ID
, POH.VENDOR_ID
, NULL
, POH.VENDOR_SITE_ID
, NULL
, POH.BILL_TO_LOCATION_ID
, NULL
, POH.CURRENCY_CODE
, POH.AUTHORIZATION_STATUS
, POH.REVISION_NUM
, PDTL.TYPE_NAME
, NULL
, POH.CREATION_DATE
, POH.APPROVED_DATE
, POH.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(NVL(PLL.RECEIPT_REQUIRED_FLAG
, 'N')
, 'N'
, '2-WAY'
, 'Y'
, DECODE(PLL.INSPECTION_REQUIRED_FLAG
, 'Y'
, '4-WAY'
, '3-WAY'))
, POD.END_ITEM_UNIT_NUMBER
, POD.RECOVERY_RATE
, POD.OKE_CONTRACT_LINE_ID
, POD.OKE_CONTRACT_DELIVERABLE_ID
, PLL.VMI_FLAG
, POH.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
, POH.STYLE_ID
FROM PO_DOCUMENT_TYPES_ALL_B PDT
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, PO_LINE_TYPES_TL PLTT
, PO_REQ_DISTRIBUTIONS_ALL PORD
, PO_REQUISITION_LINES_ALL PORL
, PO_REQUISITION_HEADERS_ALL PORH
, PO_HEADERS_ALL POH
, PO_LINE_LOCATIONS_ALL PLL
, PO_LINES_ALL POL
, PO_DISTRIBUTIONS_ALL POD
, PO_DOC_STYLE_HEADERS PDSH
, WIP_ENTITIES WP
WHERE POD.PO_HEADER_ID = POH.PO_HEADER_ID
AND POD.PO_RELEASE_ID IS NULL
AND POD.PO_LINE_ID = POL.PO_LINE_ID
AND POD.LINE_LOCATION_ID = PLL.LINE_LOCATION_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.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 NVL(PDT.ORG_ID
, -99) = NVL(PDTL.ORG_ID
, -99)
AND (PDT.ORG_ID IS NULL OR PDT.ORG_ID = POD.ORG_ID)
AND (PDTL.ORG_ID IS NULL OR PDTL.ORG_ID = POD.ORG_ID)
AND PLL.SHIPMENT_TYPE != 'PRICE BREAK'
AND PLTT.LINE_TYPE_ID (+) = POL.LINE_TYPE_ID
AND PLTT.LANGUAGE(+) = USERENV('LANG')
AND POH.STYLE_ID=PDSH.STYLE_ID
AND NVL(PDSH.PROGRESS_PAYMENT_FLAG
, 'N') = 'N'
AND POD.WIP_ENTITY_ID = WP.WIP_ENTITY_ID(+) UNION ALL 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
, WP.WIP_ENTITY_NAME
, NULL
, NULL
, NULL
, POH.SEGMENT1
, POH.TYPE_LOOKUP_CODE
, POR.RELEASE_NUM
, POR.RELEASE_TYPE
, POR.AGENT_ID
, POH.VENDOR_ID
, NULL
, POH.VENDOR_SITE_ID
, NULL
, POH.BILL_TO_LOCATION_ID
, NULL
, POH.CURRENCY_CODE
, POR.AUTHORIZATION_STATUS
, POR.REVISION_NUM
, PDTL2.TYPE_NAME
, NULL
, POR.CREATION_DATE
, POR.APPROVED_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 (NVL(PLL.RECEIPT_REQUIRED_FLAG
, 'N')
, 'N'
, '2-WAY'
, 'Y'
, DECODE(PLL.INSPECTION_REQUIRED_FLAG
, 'Y'
, '4-WAY'
, '3-WAY'))
, POD.END_ITEM_UNIT_NUMBER
, POD.RECOVERY_RATE
, POD.OKE_CONTRACT_LINE_ID
, POD.OKE_CONTRACT_DELIVERABLE_ID
, PLL.VMI_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
, POH.STYLE_ID
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
, PO_DOC_STYLE_HEADERS PDSH
, PO_SYSTEM_PARAMETERS PSP
, WIP_ENTITIES WP
WHERE POD.PO_HEADER_ID = POH.PO_HEADER_ID
AND POD.PO_RELEASE_ID = POR.PO_RELEASE_ID
AND POD.PO_LINE_ID = POL.PO_LINE_ID
AND POD.LINE_LOCATION_ID = PLL.LINE_LOCATION_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.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 NVL(PDT.ORG_ID
, -99) = NVL(PDTL.ORG_ID
, -99)
AND (PDT.ORG_ID IS NULL OR PDT.ORG_ID = POD.ORG_ID)
AND (PDTL.ORG_ID IS NULL OR PDTL.ORG_ID = POD.ORG_ID)
AND PDTB2.DOCUMENT_TYPE_CODE(+) = 'RELEASE'
AND PDTB2.DOCUMENT_SUBTYPE(+) = POR.RELEASE_TYPE
AND PDTB2.DOCUMENT_TYPE_CODE = PDTL2.DOCUMENT_TYPE_CODE(+)
AND PDTB2.DOCUMENT_SUBTYPE = PDTL2.DOCUMENT_SUBTYPE(+)
AND NVL(PDTB2.ORG_ID
, -99) = NVL(PDTL2.ORG_ID
, -99)
AND (PDTB2.ORG_ID IS NULL OR PSP.ORG_ID = PDTB2.ORG_ID)
AND PDTL2.LANGUAGE(+) = USERENV('LANG')
AND PLTT.LINE_TYPE_ID (+) = POL.LINE_TYPE_ID
AND PLTT.LANGUAGE(+) = USERENV('LANG')
AND POH.STYLE_ID=PDSH.STYLE_ID
AND NVL(PDSH.PROGRESS_PAYMENT_FLAG
, 'N') = 'N'
AND POD.WIP_ENTITY_ID = WP.WIP_ENTITY_ID(+) UNION ALL 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
, POD.QUANTITY_BILLED
, POD.QUANTITY_CANCELLED
, 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
, NULL
, 'N'
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, POH.SEGMENT1
, POH.TYPE_LOOKUP_CODE
, NULL
, NULL
, POH.AGENT_ID
, POH.VENDOR_ID
, NULL
, POH.VENDOR_SITE_ID
, NULL
, POH.BILL_TO_LOCATION_ID
, NULL
, POH.CURRENCY_CODE
, POH.AUTHORIZATION_STATUS
, POH.REVISION_NUM
, PDTL.TYPE_NAME
, NULL
, POH.CREATION_DATE
, POH.APPROVED_DATE
, POH.REVISED_DATE
, NULL
, POH.ACCEPTANCE_DUE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'OPEN'
, NULL
, NULL
, NULL
, NULL
, POD.END_ITEM_UNIT_NUMBER
, POD.RECOVERY_RATE
, POD.OKE_CONTRACT_LINE_ID
, POD.OKE_CONTRACT_DELIVERABLE_ID
, NULL
, POH.CONSIGNED_CONSUMPTION_FLAG
, NULL
, NULL
, POD.AMOUNT_ORDERED
, POD.AMOUNT_DELIVERED
, POD.AMOUNT_CANCELLED
, POD.INVOICE_ADJUSTMENT_FLAG
, POD.AWARD_ID
, NULL
, POH.ORG_ID
, POH.ORG_ID
, POD.DEST_CHARGE_ACCOUNT_ID
, POD.DEST_VARIANCE_ACCOUNT_ID
, PDT.SECURITY_LEVEL_CODE
, POH.STYLE_ID
FROM PO_DOCUMENT_TYPES_ALL_B PDT
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, PO_HEADERS_ALL POH
, PO_DISTRIBUTIONS_ALL POD
, PO_DOC_STYLE_HEADERS PDSH
WHERE POD.PO_HEADER_ID = POH.PO_HEADER_ID
AND POH.ENCUMBRANCE_REQUIRED_FLAG = 'Y'
AND POD.DISTRIBUTION_TYPE = 'AGREEMENT'
AND PDT.DOCUMENT_TYPE_CODE = 'PA'
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 NVL(PDT.ORG_ID
, -99) = NVL(PDTL.ORG_ID
, -99)
AND (PDT.ORG_ID IS NULL OR PDT.ORG_ID = POD.ORG_ID)
AND (PDTL.ORG_ID IS NULL OR PDTL.ORG_ID = POD.ORG_ID)
AND POH.STYLE_ID=PDSH.STYLE_ID
AND NVL(PDSH.PROGRESS_PAYMENT_FLAG
, 'N') = 'N'