VIEW: APPS.PO_LINE_LOCATIONS_MERGE_V

Source

View Text - Preformatted

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.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 ,PLLD.AMOUNT_SHIPPED ,PLLD.TAX_ATTRIBUTE_UPDATE_CODE ,PLLD.OUTSOURCED_ASSEMBLY ,PLLD.TAX_NAME FROM po_line_locations_draft_all PLLD, po_drafts DFT WHERE PLLD.draft_id = DFT.draft_id AND NVL(PLLD.delete_flag, 'N') = 'N' 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.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 ,PLL.AMOUNT_SHIPPED ,PLL.TAX_ATTRIBUTE_UPDATE_CODE ,PLL.OUTSOURCED_ASSEMBLY ,PLL.TAX_NAME 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')

View Text - HTML Formatted

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.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
, PLLD.AMOUNT_SHIPPED
, PLLD.TAX_ATTRIBUTE_UPDATE_CODE
, PLLD.OUTSOURCED_ASSEMBLY
, PLLD.TAX_NAME
FROM PO_LINE_LOCATIONS_DRAFT_ALL PLLD
, PO_DRAFTS DFT
WHERE PLLD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PLLD.DELETE_FLAG
, 'N') = 'N'
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.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
, PLL.AMOUNT_SHIPPED
, PLL.TAX_ATTRIBUTE_UPDATE_CODE
, PLL.OUTSOURCED_ASSEMBLY
, PLL.TAX_NAME
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')