Product: | PO - Purchasing |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PO_LINE_LOCATIONS_MERGE_V |
SELECT DFT.OWNER_USER_ID
, DFT.OWNER_ROLE
, DFT.STATUS
, DFT.DRAFT_ID
, PLLD.CHANGE_ACCEPTED_FLAG
, PLLD.DELETE_FLAG
, PLLD.USSGL_TRANSACTION_CODE
, PLLD.GOVERNMENT_CONTEXT
, PLLD.RECEIVING_ROUTING_ID
, PLLD.ACCRUE_ON_RECEIPT_FLAG
, PLLD.CLOSED_REASON
, PLLD.CLOSED_DATE
, PLLD.CLOSED_BY
, PLLD.ORG_ID
, PLLD.ATTRIBUTE6
, PLLD.ATTRIBUTE7
, PLLD.ATTRIBUTE8
, PLLD.ATTRIBUTE9
, PLLD.ATTRIBUTE10
, PLLD.UNIT_OF_MEASURE_CLASS
, PLLD.ENCUMBER_NOW
, PLLD.ATTRIBUTE11
, PLLD.ATTRIBUTE12
, PLLD.ATTRIBUTE13
, PLLD.ATTRIBUTE14
, PLLD.ATTRIBUTE15
, PLLD.INSPECTION_REQUIRED_FLAG
, PLLD.RECEIPT_REQUIRED_FLAG
, PLLD.QTY_RCV_TOLERANCE
, PLLD.QTY_RCV_EXCEPTION_CODE
, PLLD.ENFORCE_SHIP_TO_LOCATION_CODE
, PLLD.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, PLLD.DAYS_EARLY_RECEIPT_ALLOWED
, PLLD.DAYS_LATE_RECEIPT_ALLOWED
, PLLD.RECEIPT_DAYS_EXCEPTION_CODE
, PLLD.INVOICE_CLOSE_TOLERANCE
, PLLD.RECEIVE_CLOSE_TOLERANCE
, PLLD.SHIP_TO_ORGANIZATION_ID
, PLLD.SHIPMENT_NUM
, PLLD.SOURCE_SHIPMENT_ID
, PLLD.SHIPMENT_TYPE
, PLLD.CLOSED_CODE
, PLLD.REQUEST_ID
, PLLD.PROGRAM_APPLICATION_ID
, PLLD.PROGRAM_ID
, PLLD.PROGRAM_UPDATE_DATE
, PLLD.PROMISED_DATE
, PLLD.LAST_ACCEPT_DATE
, PLLD.PRICE_OVERRIDE
, PLLD.ENCUMBERED_FLAG
, PLLD.ENCUMBERED_DATE
, PLLD.UNENCUMBERED_QUANTITY
, PLLD.FOB_LOOKUP_CODE
, PLLD.FREIGHT_TERMS_LOOKUP_CODE
, PLLD.TAXABLE_FLAG
, PLLD.ESTIMATED_TAX_AMOUNT
, PLLD.FROM_HEADER_ID
, PLLD.FROM_LINE_ID
, PLLD.FROM_LINE_LOCATION_ID
, PLLD.START_DATE
, PLLD.END_DATE
, PLLD.LEAD_TIME
, PLLD.LEAD_TIME_UNIT
, PLLD.PRICE_DISCOUNT
, PLLD.TERMS_ID
, PLLD.APPROVED_FLAG
, PLLD.APPROVED_DATE
, PLLD.CLOSED_FLAG
, PLLD.CANCEL_FLAG
, PLLD.CANCELLED_BY
, PLLD.CANCEL_DATE
, PLLD.CANCEL_REASON
, PLLD.FIRM_STATUS_LOOKUP_CODE
, PLLD.FIRM_DATE
, PLLD.ATTRIBUTE_CATEGORY
, PLLD.ATTRIBUTE1
, PLLD.ATTRIBUTE2
, PLLD.ATTRIBUTE3
, PLLD.ATTRIBUTE4
, PLLD.ATTRIBUTE5
, PLLD.LINE_LOCATION_ID
, PLLD.LAST_UPDATE_DATE
, PLLD.LAST_UPDATED_BY
, PLLD.PO_HEADER_ID
, PLLD.PO_LINE_ID
, PLLD.LAST_UPDATE_LOGIN
, PLLD.CREATION_DATE
, PLLD.CREATED_BY
, PLLD.QUANTITY
, PLLD.QUANTITY_RECEIVED
, PLLD.QUANTITY_ACCEPTED
, PLLD.QUANTITY_REJECTED
, PLLD.QUANTITY_BILLED
, PLLD.QUANTITY_CANCELLED
, PLLD.UNIT_MEAS_LOOKUP_CODE
, PLLD.PO_RELEASE_ID
, PLLD.SHIP_TO_LOCATION_ID
, PLLD.SHIP_VIA_LOOKUP_CODE
, PLLD.NEED_BY_DATE
, PLLD.GLOBAL_ATTRIBUTE_CATEGORY
, PLLD.GLOBAL_ATTRIBUTE1
, PLLD.GLOBAL_ATTRIBUTE2
, PLLD.GLOBAL_ATTRIBUTE3
, PLLD.GLOBAL_ATTRIBUTE4
, PLLD.GLOBAL_ATTRIBUTE5
, PLLD.GLOBAL_ATTRIBUTE6
, PLLD.GLOBAL_ATTRIBUTE7
, PLLD.GLOBAL_ATTRIBUTE8
, PLLD.GLOBAL_ATTRIBUTE9
, PLLD.GLOBAL_ATTRIBUTE10
, PLLD.GLOBAL_ATTRIBUTE11
, PLLD.GLOBAL_ATTRIBUTE12
, PLLD.GLOBAL_ATTRIBUTE13
, PLLD.GLOBAL_ATTRIBUTE14
, PLLD.GLOBAL_ATTRIBUTE15
, PLLD.GLOBAL_ATTRIBUTE16
, PLLD.GLOBAL_ATTRIBUTE17
, PLLD.GLOBAL_ATTRIBUTE18
, PLLD.GLOBAL_ATTRIBUTE19
, PLLD.GLOBAL_ATTRIBUTE20
, PLLD.QUANTITY_SHIPPED
, PLLD.COUNTRY_OF_ORIGIN_CODE
, PLLD.TAX_USER_OVERRIDE_FLAG
, PLLD.MATCH_OPTION
, PLLD.TAX_CODE_ID
, PLLD.CALCULATE_TAX_FLAG
, PLLD.CHANGE_PROMISED_DATE_REASON
, PLLD.NOTE_TO_RECEIVER
, PLLD.SECONDARY_UNIT_OF_MEASURE
, PLLD.SECONDARY_QUANTITY
, PLLD.PREFERRED_GRADE
, PLLD.SECONDARY_QUANTITY_RECEIVED
, PLLD.SECONDARY_QUANTITY_ACCEPTED
, PLLD.SECONDARY_QUANTITY_REJECTED
, PLLD.SECONDARY_QUANTITY_CANCELLED
, PLLD.VMI_FLAG
, PLLD.CONSIGNED_FLAG
, PLLD.RETROACTIVE_DATE
, PLLD.SUPPLIER_ORDER_LINE_NUMBER
, PLLD.AMOUNT
, PLLD.AMOUNT_RECEIVED
, PLLD.AMOUNT_BILLED
, PLLD.AMOUNT_CANCELLED
, PLLD.AMOUNT_ACCEPTED
, PLLD.AMOUNT_REJECTED
, PLLD.DROP_SHIP_FLAG
, PLLD.SALES_ORDER_UPDATE_DATE
, PLLD.TRANSACTION_FLOW_HEADER_ID
, PLLD.FINAL_MATCH_FLAG
, PLLD.MANUAL_PRICE_CHANGE_FLAG
, PLLD.SHIPMENT_CLOSED_DATE
, PLLD.CLOSED_FOR_RECEIVING_DATE
, PLLD.CLOSED_FOR_INVOICE_DATE
, PLLD.SECONDARY_QUANTITY_SHIPPED
, PLLD.VALUE_BASIS
, PLLD.MATCHING_BASIS
, PLLD.PAYMENT_TYPE
, PLLD.GROUP_NAME
, PLLD.DESCRIPTION
, PLLD.WORK_APPROVER_ID
, PLLD.BID_PAYMENT_ID
, PLLD.QUANTITY_FINANCED
, PLLD.AMOUNT_FINANCED
, PLLD.QUANTITY_RECOUPED
, PLLD.AMOUNT_RECOUPED
, PLLD.RETAINAGE_WITHHELD_AMOUNT
, PLLD.RETAINAGE_RELEASED_AMOUNT
FROM PO_LINE_LOCATIONS_DRAFT_ALL PLLD
, PO_DRAFTS DFT
WHERE PLLD.DRAFT_ID = DFT.DRAFT_ID
AND PLLD.DELETE_FLAG IS NULL
AND DFT.OWNER_ROLE = PO_GLOBAL.ROLE
AND DFT.STATUS <> 'COMPLETED' UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, PLL.USSGL_TRANSACTION_CODE
, PLL.GOVERNMENT_CONTEXT
, PLL.RECEIVING_ROUTING_ID
, PLL.ACCRUE_ON_RECEIPT_FLAG
, PLL.CLOSED_REASON
, PLL.CLOSED_DATE
, PLL.CLOSED_BY
, PLL.ORG_ID
, PLL.ATTRIBUTE6
, PLL.ATTRIBUTE7
, PLL.ATTRIBUTE8
, PLL.ATTRIBUTE9
, PLL.ATTRIBUTE10
, PLL.UNIT_OF_MEASURE_CLASS
, PLL.ENCUMBER_NOW
, PLL.ATTRIBUTE11
, PLL.ATTRIBUTE12
, PLL.ATTRIBUTE13
, PLL.ATTRIBUTE14
, PLL.ATTRIBUTE15
, PLL.INSPECTION_REQUIRED_FLAG
, PLL.RECEIPT_REQUIRED_FLAG
, PLL.QTY_RCV_TOLERANCE
, PLL.QTY_RCV_EXCEPTION_CODE
, PLL.ENFORCE_SHIP_TO_LOCATION_CODE
, PLL.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED
, PLL.RECEIPT_DAYS_EXCEPTION_CODE
, PLL.INVOICE_CLOSE_TOLERANCE
, PLL.RECEIVE_CLOSE_TOLERANCE
, PLL.SHIP_TO_ORGANIZATION_ID
, PLL.SHIPMENT_NUM
, PLL.SOURCE_SHIPMENT_ID
, PLL.SHIPMENT_TYPE
, PLL.CLOSED_CODE
, PLL.REQUEST_ID
, PLL.PROGRAM_APPLICATION_ID
, PLL.PROGRAM_ID
, PLL.PROGRAM_UPDATE_DATE
, PLL.PROMISED_DATE
, PLL.LAST_ACCEPT_DATE
, PLL.PRICE_OVERRIDE
, PLL.ENCUMBERED_FLAG
, PLL.ENCUMBERED_DATE
, PLL.UNENCUMBERED_QUANTITY
, PLL.FOB_LOOKUP_CODE
, PLL.FREIGHT_TERMS_LOOKUP_CODE
, PLL.TAXABLE_FLAG
, PLL.ESTIMATED_TAX_AMOUNT
, PLL.FROM_HEADER_ID
, PLL.FROM_LINE_ID
, PLL.FROM_LINE_LOCATION_ID
, PLL.START_DATE
, PLL.END_DATE
, PLL.LEAD_TIME
, PLL.LEAD_TIME_UNIT
, PLL.PRICE_DISCOUNT
, PLL.TERMS_ID
, PLL.APPROVED_FLAG
, PLL.APPROVED_DATE
, PLL.CLOSED_FLAG
, PLL.CANCEL_FLAG
, PLL.CANCELLED_BY
, PLL.CANCEL_DATE
, PLL.CANCEL_REASON
, PLL.FIRM_STATUS_LOOKUP_CODE
, PLL.FIRM_DATE
, PLL.ATTRIBUTE_CATEGORY
, PLL.ATTRIBUTE1
, PLL.ATTRIBUTE2
, PLL.ATTRIBUTE3
, PLL.ATTRIBUTE4
, PLL.ATTRIBUTE5
, PLL.LINE_LOCATION_ID
, PLL.LAST_UPDATE_DATE
, PLL.LAST_UPDATED_BY
, PLL.PO_HEADER_ID
, PLL.PO_LINE_ID
, PLL.LAST_UPDATE_LOGIN
, PLL.CREATION_DATE
, PLL.CREATED_BY
, PLL.QUANTITY
, PLL.QUANTITY_RECEIVED
, PLL.QUANTITY_ACCEPTED
, PLL.QUANTITY_REJECTED
, PLL.QUANTITY_BILLED
, PLL.QUANTITY_CANCELLED
, PLL.UNIT_MEAS_LOOKUP_CODE
, PLL.PO_RELEASE_ID
, PLL.SHIP_TO_LOCATION_ID
, PLL.SHIP_VIA_LOOKUP_CODE
, PLL.NEED_BY_DATE
, PLL.GLOBAL_ATTRIBUTE_CATEGORY
, PLL.GLOBAL_ATTRIBUTE1
, PLL.GLOBAL_ATTRIBUTE2
, PLL.GLOBAL_ATTRIBUTE3
, PLL.GLOBAL_ATTRIBUTE4
, PLL.GLOBAL_ATTRIBUTE5
, PLL.GLOBAL_ATTRIBUTE6
, PLL.GLOBAL_ATTRIBUTE7
, PLL.GLOBAL_ATTRIBUTE8
, PLL.GLOBAL_ATTRIBUTE9
, PLL.GLOBAL_ATTRIBUTE10
, PLL.GLOBAL_ATTRIBUTE11
, PLL.GLOBAL_ATTRIBUTE12
, PLL.GLOBAL_ATTRIBUTE13
, PLL.GLOBAL_ATTRIBUTE14
, PLL.GLOBAL_ATTRIBUTE15
, PLL.GLOBAL_ATTRIBUTE16
, PLL.GLOBAL_ATTRIBUTE17
, PLL.GLOBAL_ATTRIBUTE18
, PLL.GLOBAL_ATTRIBUTE19
, PLL.GLOBAL_ATTRIBUTE20
, PLL.QUANTITY_SHIPPED
, PLL.COUNTRY_OF_ORIGIN_CODE
, PLL.TAX_USER_OVERRIDE_FLAG
, PLL.MATCH_OPTION
, PLL.TAX_CODE_ID
, PLL.CALCULATE_TAX_FLAG
, PLL.CHANGE_PROMISED_DATE_REASON
, PLL.NOTE_TO_RECEIVER
, PLL.SECONDARY_UNIT_OF_MEASURE
, PLL.SECONDARY_QUANTITY
, PLL.PREFERRED_GRADE
, PLL.SECONDARY_QUANTITY_RECEIVED
, PLL.SECONDARY_QUANTITY_ACCEPTED
, PLL.SECONDARY_QUANTITY_REJECTED
, PLL.SECONDARY_QUANTITY_CANCELLED
, PLL.VMI_FLAG
, PLL.CONSIGNED_FLAG
, PLL.RETROACTIVE_DATE
, PLL.SUPPLIER_ORDER_LINE_NUMBER
, PLL.AMOUNT
, PLL.AMOUNT_RECEIVED
, PLL.AMOUNT_BILLED
, PLL.AMOUNT_CANCELLED
, PLL.AMOUNT_ACCEPTED
, PLL.AMOUNT_REJECTED
, PLL.DROP_SHIP_FLAG
, PLL.SALES_ORDER_UPDATE_DATE
, PLL.TRANSACTION_FLOW_HEADER_ID
, PLL.FINAL_MATCH_FLAG
, PLL.MANUAL_PRICE_CHANGE_FLAG
, PLL.SHIPMENT_CLOSED_DATE
, PLL.CLOSED_FOR_RECEIVING_DATE
, PLL.CLOSED_FOR_INVOICE_DATE
, PLL.SECONDARY_QUANTITY_SHIPPED
, PLL.VALUE_BASIS
, PLL.MATCHING_BASIS
, PLL.PAYMENT_TYPE
, PLL.GROUP_NAME
, PLL.DESCRIPTION
, PLL.WORK_APPROVER_ID
, PLL.BID_PAYMENT_ID
, PLL.QUANTITY_FINANCED
, PLL.AMOUNT_FINANCED
, PLL.QUANTITY_RECOUPED
, PLL.AMOUNT_RECOUPED
, PLL.RETAINAGE_WITHHELD_AMOUNT
, PLL.RETAINAGE_RELEASED_AMOUNT
FROM PO_LINE_LOCATIONS_ALL PLL
WHERE NOT EXISTS ( SELECT 1
FROM PO_LINE_LOCATIONS_DRAFT_ALL PLLD1
, PO_DRAFTS DFT1
WHERE PLL.LINE_LOCATION_ID = PLLD1.LINE_LOCATION_ID
AND PLLD1.DRAFT_ID = DFT1.DRAFT_ID
AND DFT1.OWNER_ROLE = PO_GLOBAL.ROLE
AND DFT1.STATUS <> 'COMPLETED')