VIEW: APPS.PO_LINES_MERGE_V

Source

View Text - Preformatted

SELECT DFT.owner_user_id , DFT.owner_role , DFT.status , DFT.draft_id , PLD.CHANGE_ACCEPTED_FLAG , PLD.DELETE_FLAG , PLD.ATTRIBUTE9 , PLD.ATTRIBUTE10 , PLD.REFERENCE_NUM , PLD.ATTRIBUTE11 , PLD.ATTRIBUTE12 , PLD.ATTRIBUTE13 , PLD.ATTRIBUTE14 , PLD.ATTRIBUTE15 , PLD.MIN_RELEASE_AMOUNT , PLD.PRICE_TYPE_LOOKUP_CODE , PLD.CLOSED_CODE , PLD.PRICE_BREAK_LOOKUP_CODE , PLD.USSGL_TRANSACTION_CODE , PLD.GOVERNMENT_CONTEXT , PLD.REQUEST_ID , PLD.PROGRAM_APPLICATION_ID , PLD.PROGRAM_ID , PLD.PROGRAM_UPDATE_DATE , PLD.CLOSED_DATE , PLD.CLOSED_REASON , PLD.CLOSED_BY , PLD.TRANSACTION_REASON_CODE , PLD.ORG_ID , PLD.HAZARD_CLASS_ID , PLD.NOTE_TO_VENDOR , PLD.FROM_HEADER_ID , PLD.FROM_LINE_ID , PLD.MIN_ORDER_QUANTITY , PLD.MAX_ORDER_QUANTITY , PLD.QTY_RCV_TOLERANCE , PLD.OVER_TOLERANCE_ERROR_FLAG , PLD.MARKET_PRICE , PLD.UNORDERED_FLAG , PLD.CLOSED_FLAG , PLD.USER_HOLD_FLAG , PLD.CANCEL_FLAG , PLD.CANCELLED_BY , PLD.CANCEL_DATE , PLD.CANCEL_REASON , PLD.FIRM_STATUS_LOOKUP_CODE , PLD.FIRM_DATE , PLD.VENDOR_PRODUCT_NUM , PLD.CONTRACT_NUM , PLD.TAXABLE_FLAG , PLD.TYPE_1099 , PLD.CAPITAL_EXPENSE_FLAG , PLD.NEGOTIATED_BY_PREPARER_FLAG , PLD.ATTRIBUTE_CATEGORY , PLD.ATTRIBUTE1 , PLD.ATTRIBUTE2 , PLD.ATTRIBUTE3 , PLD.ATTRIBUTE4 , PLD.ATTRIBUTE5 , PLD.ATTRIBUTE6 , PLD.ATTRIBUTE7 , PLD.ATTRIBUTE8 , PLD.QC_GRADE , PLD.BASE_UOM , PLD.BASE_QTY , PLD.SECONDARY_UOM , PLD.SECONDARY_QTY , PLD.PO_LINE_ID , PLD.LAST_UPDATE_DATE , PLD.LAST_UPDATED_BY , PLD.PO_HEADER_ID , PLD.LINE_TYPE_ID , PLD.LINE_NUM , PLD.LAST_UPDATE_LOGIN , PLD.CREATION_DATE , PLD.CREATED_BY , PLD.ITEM_ID , PLD.ITEM_REVISION , PLD.CATEGORY_ID , PLD.ITEM_DESCRIPTION , PLD.UNIT_MEAS_LOOKUP_CODE , PLD.QUANTITY_COMMITTED , PLD.COMMITTED_AMOUNT , PLD.ALLOW_PRICE_OVERRIDE_FLAG , PLD.NOT_TO_EXCEED_PRICE , PLD.LIST_PRICE_PER_UNIT , PLD.UNIT_PRICE , PLD.QUANTITY , PLD.UN_NUMBER_ID , PLD.GLOBAL_ATTRIBUTE_CATEGORY , PLD.GLOBAL_ATTRIBUTE1 , PLD.GLOBAL_ATTRIBUTE2 , PLD.GLOBAL_ATTRIBUTE3 , PLD.GLOBAL_ATTRIBUTE4 , PLD.GLOBAL_ATTRIBUTE5 , PLD.GLOBAL_ATTRIBUTE6 , PLD.GLOBAL_ATTRIBUTE7 , PLD.GLOBAL_ATTRIBUTE8 , PLD.GLOBAL_ATTRIBUTE9 , PLD.GLOBAL_ATTRIBUTE10 , PLD.GLOBAL_ATTRIBUTE11 , PLD.GLOBAL_ATTRIBUTE12 , PLD.GLOBAL_ATTRIBUTE13 , PLD.GLOBAL_ATTRIBUTE14 , PLD.GLOBAL_ATTRIBUTE15 , PLD.GLOBAL_ATTRIBUTE16 , PLD.GLOBAL_ATTRIBUTE17 , PLD.GLOBAL_ATTRIBUTE18 , PLD.GLOBAL_ATTRIBUTE19 , PLD.GLOBAL_ATTRIBUTE20 , PLD.LINE_REFERENCE_NUM , PLD.PROJECT_ID , PLD.TASK_ID , PLD.EXPIRATION_DATE , PLD.TAX_CODE_ID , PLD.OKE_CONTRACT_HEADER_ID , PLD.OKE_CONTRACT_VERSION_ID , PLD.TAX_NAME , PLD.SECONDARY_UNIT_OF_MEASURE , PLD.SECONDARY_QUANTITY , PLD.PREFERRED_GRADE , PLD.AUCTION_HEADER_ID , PLD.AUCTION_DISPLAY_NUMBER , PLD.AUCTION_LINE_NUMBER , PLD.BID_NUMBER , PLD.BID_LINE_NUMBER , PLD.RETROACTIVE_DATE , PLD.SUPPLIER_REF_NUMBER , PLD.CONTRACT_ID , PLD.JOB_ID , PLD.AMOUNT , PLD.START_DATE , PLD.CONTRACTOR_FIRST_NAME , PLD.CONTRACTOR_LAST_NAME , PLD.ORDER_TYPE_LOOKUP_CODE , PLD.PURCHASE_BASIS , PLD.MATCHING_BASIS , PLD.SVC_AMOUNT_NOTIF_SENT , PLD.SVC_COMPLETION_NOTIF_SENT , PLD.FROM_LINE_LOCATION_ID , PLD.BASE_UNIT_PRICE , PLD.MANUAL_PRICE_CHANGE_FLAG ,PLD.RETAINAGE_RATE ,PLD.MAX_RETAINAGE_AMOUNT ,PLD.PROGRESS_PAYMENT_RATE ,PLD.RECOUPMENT_RATE ,PLD.SUPPLIER_PART_AUXID ,PLD.IP_CATEGORY_ID ,PLD.TAX_ATTRIBUTE_UPDATE_CODE ,PLD.CATALOG_NAME FROM PO_LINES_DRAFT_ALL PLD, PO_DRAFTS DFT WHERE PLD.draft_id = DFT.draft_id AND NVL(PLD.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 , PL.ATTRIBUTE9 , PL.ATTRIBUTE10 , PL.REFERENCE_NUM , PL.ATTRIBUTE11 , PL.ATTRIBUTE12 , PL.ATTRIBUTE13 , PL.ATTRIBUTE14 , PL.ATTRIBUTE15 , PL.MIN_RELEASE_AMOUNT , PL.PRICE_TYPE_LOOKUP_CODE , PL.CLOSED_CODE , PL.PRICE_BREAK_LOOKUP_CODE , PL.USSGL_TRANSACTION_CODE , PL.GOVERNMENT_CONTEXT , PL.REQUEST_ID , PL.PROGRAM_APPLICATION_ID , PL.PROGRAM_ID , PL.PROGRAM_UPDATE_DATE , PL.CLOSED_DATE , PL.CLOSED_REASON , PL.CLOSED_BY , PL.TRANSACTION_REASON_CODE , PL.ORG_ID , PL.HAZARD_CLASS_ID , PL.NOTE_TO_VENDOR , PL.FROM_HEADER_ID , PL.FROM_LINE_ID , PL.MIN_ORDER_QUANTITY , PL.MAX_ORDER_QUANTITY , PL.QTY_RCV_TOLERANCE , PL.OVER_TOLERANCE_ERROR_FLAG , PL.MARKET_PRICE , PL.UNORDERED_FLAG , PL.CLOSED_FLAG , PL.USER_HOLD_FLAG , PL.CANCEL_FLAG , PL.CANCELLED_BY , PL.CANCEL_DATE , PL.CANCEL_REASON , PL.FIRM_STATUS_LOOKUP_CODE , PL.FIRM_DATE , PL.VENDOR_PRODUCT_NUM , PL.CONTRACT_NUM , PL.TAXABLE_FLAG , PL.TYPE_1099 , PL.CAPITAL_EXPENSE_FLAG , PL.NEGOTIATED_BY_PREPARER_FLAG , PL.ATTRIBUTE_CATEGORY , PL.ATTRIBUTE1 , PL.ATTRIBUTE2 , PL.ATTRIBUTE3 , PL.ATTRIBUTE4 , PL.ATTRIBUTE5 , PL.ATTRIBUTE6 , PL.ATTRIBUTE7 , PL.ATTRIBUTE8 , PL.QC_GRADE , PL.BASE_UOM , PL.BASE_QTY , PL.SECONDARY_UOM , PL.SECONDARY_QTY , PL.PO_LINE_ID , PL.LAST_UPDATE_DATE , PL.LAST_UPDATED_BY , PL.PO_HEADER_ID , PL.LINE_TYPE_ID , PL.LINE_NUM , PL.LAST_UPDATE_LOGIN , PL.CREATION_DATE , PL.CREATED_BY , PL.ITEM_ID , PL.ITEM_REVISION , PL.CATEGORY_ID , PL.ITEM_DESCRIPTION , PL.UNIT_MEAS_LOOKUP_CODE , PL.QUANTITY_COMMITTED , PL.COMMITTED_AMOUNT , PL.ALLOW_PRICE_OVERRIDE_FLAG , PL.NOT_TO_EXCEED_PRICE , PL.LIST_PRICE_PER_UNIT , PL.UNIT_PRICE , PL.QUANTITY , PL.UN_NUMBER_ID , PL.GLOBAL_ATTRIBUTE_CATEGORY , PL.GLOBAL_ATTRIBUTE1 , PL.GLOBAL_ATTRIBUTE2 , PL.GLOBAL_ATTRIBUTE3 , PL.GLOBAL_ATTRIBUTE4 , PL.GLOBAL_ATTRIBUTE5 , PL.GLOBAL_ATTRIBUTE6 , PL.GLOBAL_ATTRIBUTE7 , PL.GLOBAL_ATTRIBUTE8 , PL.GLOBAL_ATTRIBUTE9 , PL.GLOBAL_ATTRIBUTE10 , PL.GLOBAL_ATTRIBUTE11 , PL.GLOBAL_ATTRIBUTE12 , PL.GLOBAL_ATTRIBUTE13 , PL.GLOBAL_ATTRIBUTE14 , PL.GLOBAL_ATTRIBUTE15 , PL.GLOBAL_ATTRIBUTE16 , PL.GLOBAL_ATTRIBUTE17 , PL.GLOBAL_ATTRIBUTE18 , PL.GLOBAL_ATTRIBUTE19 , PL.GLOBAL_ATTRIBUTE20 , PL.LINE_REFERENCE_NUM , PL.PROJECT_ID , PL.TASK_ID , PL.EXPIRATION_DATE , PL.TAX_CODE_ID , PL.OKE_CONTRACT_HEADER_ID , PL.OKE_CONTRACT_VERSION_ID , PL.TAX_NAME , PL.SECONDARY_UNIT_OF_MEASURE , PL.SECONDARY_QUANTITY , PL.PREFERRED_GRADE , PL.AUCTION_HEADER_ID , PL.AUCTION_DISPLAY_NUMBER , PL.AUCTION_LINE_NUMBER , PL.BID_NUMBER , PL.BID_LINE_NUMBER , PL.RETROACTIVE_DATE , PL.SUPPLIER_REF_NUMBER , PL.CONTRACT_ID , PL.JOB_ID , PL.AMOUNT , PL.START_DATE , PL.CONTRACTOR_FIRST_NAME , PL.CONTRACTOR_LAST_NAME , PL.ORDER_TYPE_LOOKUP_CODE , PL.PURCHASE_BASIS , PL.MATCHING_BASIS , PL.SVC_AMOUNT_NOTIF_SENT , PL.SVC_COMPLETION_NOTIF_SENT , PL.FROM_LINE_LOCATION_ID , PL.BASE_UNIT_PRICE , PL.MANUAL_PRICE_CHANGE_FLAG , PL.RETAINAGE_RATE , PL.MAX_RETAINAGE_AMOUNT , PL.PROGRESS_PAYMENT_RATE , PL.RECOUPMENT_RATE , PL.SUPPLIER_PART_AUXID , PL.IP_CATEGORY_ID , PL.TAX_ATTRIBUTE_UPDATE_CODE , PL.catalog_name FROM PO_LINES_ALL PL WHERE NOT EXISTS ( SELECT 1 FROM PO_LINES_DRAFT_ALL PLD1, PO_DRAFTS DFT1 WHERE PL.po_line_id = PLD1.po_line_id AND PLD1.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
, PLD.CHANGE_ACCEPTED_FLAG
, PLD.DELETE_FLAG
, PLD.ATTRIBUTE9
, PLD.ATTRIBUTE10
, PLD.REFERENCE_NUM
, PLD.ATTRIBUTE11
, PLD.ATTRIBUTE12
, PLD.ATTRIBUTE13
, PLD.ATTRIBUTE14
, PLD.ATTRIBUTE15
, PLD.MIN_RELEASE_AMOUNT
, PLD.PRICE_TYPE_LOOKUP_CODE
, PLD.CLOSED_CODE
, PLD.PRICE_BREAK_LOOKUP_CODE
, PLD.USSGL_TRANSACTION_CODE
, PLD.GOVERNMENT_CONTEXT
, PLD.REQUEST_ID
, PLD.PROGRAM_APPLICATION_ID
, PLD.PROGRAM_ID
, PLD.PROGRAM_UPDATE_DATE
, PLD.CLOSED_DATE
, PLD.CLOSED_REASON
, PLD.CLOSED_BY
, PLD.TRANSACTION_REASON_CODE
, PLD.ORG_ID
, PLD.HAZARD_CLASS_ID
, PLD.NOTE_TO_VENDOR
, PLD.FROM_HEADER_ID
, PLD.FROM_LINE_ID
, PLD.MIN_ORDER_QUANTITY
, PLD.MAX_ORDER_QUANTITY
, PLD.QTY_RCV_TOLERANCE
, PLD.OVER_TOLERANCE_ERROR_FLAG
, PLD.MARKET_PRICE
, PLD.UNORDERED_FLAG
, PLD.CLOSED_FLAG
, PLD.USER_HOLD_FLAG
, PLD.CANCEL_FLAG
, PLD.CANCELLED_BY
, PLD.CANCEL_DATE
, PLD.CANCEL_REASON
, PLD.FIRM_STATUS_LOOKUP_CODE
, PLD.FIRM_DATE
, PLD.VENDOR_PRODUCT_NUM
, PLD.CONTRACT_NUM
, PLD.TAXABLE_FLAG
, PLD.TYPE_1099
, PLD.CAPITAL_EXPENSE_FLAG
, PLD.NEGOTIATED_BY_PREPARER_FLAG
, PLD.ATTRIBUTE_CATEGORY
, PLD.ATTRIBUTE1
, PLD.ATTRIBUTE2
, PLD.ATTRIBUTE3
, PLD.ATTRIBUTE4
, PLD.ATTRIBUTE5
, PLD.ATTRIBUTE6
, PLD.ATTRIBUTE7
, PLD.ATTRIBUTE8
, PLD.QC_GRADE
, PLD.BASE_UOM
, PLD.BASE_QTY
, PLD.SECONDARY_UOM
, PLD.SECONDARY_QTY
, PLD.PO_LINE_ID
, PLD.LAST_UPDATE_DATE
, PLD.LAST_UPDATED_BY
, PLD.PO_HEADER_ID
, PLD.LINE_TYPE_ID
, PLD.LINE_NUM
, PLD.LAST_UPDATE_LOGIN
, PLD.CREATION_DATE
, PLD.CREATED_BY
, PLD.ITEM_ID
, PLD.ITEM_REVISION
, PLD.CATEGORY_ID
, PLD.ITEM_DESCRIPTION
, PLD.UNIT_MEAS_LOOKUP_CODE
, PLD.QUANTITY_COMMITTED
, PLD.COMMITTED_AMOUNT
, PLD.ALLOW_PRICE_OVERRIDE_FLAG
, PLD.NOT_TO_EXCEED_PRICE
, PLD.LIST_PRICE_PER_UNIT
, PLD.UNIT_PRICE
, PLD.QUANTITY
, PLD.UN_NUMBER_ID
, PLD.GLOBAL_ATTRIBUTE_CATEGORY
, PLD.GLOBAL_ATTRIBUTE1
, PLD.GLOBAL_ATTRIBUTE2
, PLD.GLOBAL_ATTRIBUTE3
, PLD.GLOBAL_ATTRIBUTE4
, PLD.GLOBAL_ATTRIBUTE5
, PLD.GLOBAL_ATTRIBUTE6
, PLD.GLOBAL_ATTRIBUTE7
, PLD.GLOBAL_ATTRIBUTE8
, PLD.GLOBAL_ATTRIBUTE9
, PLD.GLOBAL_ATTRIBUTE10
, PLD.GLOBAL_ATTRIBUTE11
, PLD.GLOBAL_ATTRIBUTE12
, PLD.GLOBAL_ATTRIBUTE13
, PLD.GLOBAL_ATTRIBUTE14
, PLD.GLOBAL_ATTRIBUTE15
, PLD.GLOBAL_ATTRIBUTE16
, PLD.GLOBAL_ATTRIBUTE17
, PLD.GLOBAL_ATTRIBUTE18
, PLD.GLOBAL_ATTRIBUTE19
, PLD.GLOBAL_ATTRIBUTE20
, PLD.LINE_REFERENCE_NUM
, PLD.PROJECT_ID
, PLD.TASK_ID
, PLD.EXPIRATION_DATE
, PLD.TAX_CODE_ID
, PLD.OKE_CONTRACT_HEADER_ID
, PLD.OKE_CONTRACT_VERSION_ID
, PLD.TAX_NAME
, PLD.SECONDARY_UNIT_OF_MEASURE
, PLD.SECONDARY_QUANTITY
, PLD.PREFERRED_GRADE
, PLD.AUCTION_HEADER_ID
, PLD.AUCTION_DISPLAY_NUMBER
, PLD.AUCTION_LINE_NUMBER
, PLD.BID_NUMBER
, PLD.BID_LINE_NUMBER
, PLD.RETROACTIVE_DATE
, PLD.SUPPLIER_REF_NUMBER
, PLD.CONTRACT_ID
, PLD.JOB_ID
, PLD.AMOUNT
, PLD.START_DATE
, PLD.CONTRACTOR_FIRST_NAME
, PLD.CONTRACTOR_LAST_NAME
, PLD.ORDER_TYPE_LOOKUP_CODE
, PLD.PURCHASE_BASIS
, PLD.MATCHING_BASIS
, PLD.SVC_AMOUNT_NOTIF_SENT
, PLD.SVC_COMPLETION_NOTIF_SENT
, PLD.FROM_LINE_LOCATION_ID
, PLD.BASE_UNIT_PRICE
, PLD.MANUAL_PRICE_CHANGE_FLAG
, PLD.RETAINAGE_RATE
, PLD.MAX_RETAINAGE_AMOUNT
, PLD.PROGRESS_PAYMENT_RATE
, PLD.RECOUPMENT_RATE
, PLD.SUPPLIER_PART_AUXID
, PLD.IP_CATEGORY_ID
, PLD.TAX_ATTRIBUTE_UPDATE_CODE
, PLD.CATALOG_NAME
FROM PO_LINES_DRAFT_ALL PLD
, PO_DRAFTS DFT
WHERE PLD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PLD.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
, PL.ATTRIBUTE9
, PL.ATTRIBUTE10
, PL.REFERENCE_NUM
, PL.ATTRIBUTE11
, PL.ATTRIBUTE12
, PL.ATTRIBUTE13
, PL.ATTRIBUTE14
, PL.ATTRIBUTE15
, PL.MIN_RELEASE_AMOUNT
, PL.PRICE_TYPE_LOOKUP_CODE
, PL.CLOSED_CODE
, PL.PRICE_BREAK_LOOKUP_CODE
, PL.USSGL_TRANSACTION_CODE
, PL.GOVERNMENT_CONTEXT
, PL.REQUEST_ID
, PL.PROGRAM_APPLICATION_ID
, PL.PROGRAM_ID
, PL.PROGRAM_UPDATE_DATE
, PL.CLOSED_DATE
, PL.CLOSED_REASON
, PL.CLOSED_BY
, PL.TRANSACTION_REASON_CODE
, PL.ORG_ID
, PL.HAZARD_CLASS_ID
, PL.NOTE_TO_VENDOR
, PL.FROM_HEADER_ID
, PL.FROM_LINE_ID
, PL.MIN_ORDER_QUANTITY
, PL.MAX_ORDER_QUANTITY
, PL.QTY_RCV_TOLERANCE
, PL.OVER_TOLERANCE_ERROR_FLAG
, PL.MARKET_PRICE
, PL.UNORDERED_FLAG
, PL.CLOSED_FLAG
, PL.USER_HOLD_FLAG
, PL.CANCEL_FLAG
, PL.CANCELLED_BY
, PL.CANCEL_DATE
, PL.CANCEL_REASON
, PL.FIRM_STATUS_LOOKUP_CODE
, PL.FIRM_DATE
, PL.VENDOR_PRODUCT_NUM
, PL.CONTRACT_NUM
, PL.TAXABLE_FLAG
, PL.TYPE_1099
, PL.CAPITAL_EXPENSE_FLAG
, PL.NEGOTIATED_BY_PREPARER_FLAG
, PL.ATTRIBUTE_CATEGORY
, PL.ATTRIBUTE1
, PL.ATTRIBUTE2
, PL.ATTRIBUTE3
, PL.ATTRIBUTE4
, PL.ATTRIBUTE5
, PL.ATTRIBUTE6
, PL.ATTRIBUTE7
, PL.ATTRIBUTE8
, PL.QC_GRADE
, PL.BASE_UOM
, PL.BASE_QTY
, PL.SECONDARY_UOM
, PL.SECONDARY_QTY
, PL.PO_LINE_ID
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.PO_HEADER_ID
, PL.LINE_TYPE_ID
, PL.LINE_NUM
, PL.LAST_UPDATE_LOGIN
, PL.CREATION_DATE
, PL.CREATED_BY
, PL.ITEM_ID
, PL.ITEM_REVISION
, PL.CATEGORY_ID
, PL.ITEM_DESCRIPTION
, PL.UNIT_MEAS_LOOKUP_CODE
, PL.QUANTITY_COMMITTED
, PL.COMMITTED_AMOUNT
, PL.ALLOW_PRICE_OVERRIDE_FLAG
, PL.NOT_TO_EXCEED_PRICE
, PL.LIST_PRICE_PER_UNIT
, PL.UNIT_PRICE
, PL.QUANTITY
, PL.UN_NUMBER_ID
, PL.GLOBAL_ATTRIBUTE_CATEGORY
, PL.GLOBAL_ATTRIBUTE1
, PL.GLOBAL_ATTRIBUTE2
, PL.GLOBAL_ATTRIBUTE3
, PL.GLOBAL_ATTRIBUTE4
, PL.GLOBAL_ATTRIBUTE5
, PL.GLOBAL_ATTRIBUTE6
, PL.GLOBAL_ATTRIBUTE7
, PL.GLOBAL_ATTRIBUTE8
, PL.GLOBAL_ATTRIBUTE9
, PL.GLOBAL_ATTRIBUTE10
, PL.GLOBAL_ATTRIBUTE11
, PL.GLOBAL_ATTRIBUTE12
, PL.GLOBAL_ATTRIBUTE13
, PL.GLOBAL_ATTRIBUTE14
, PL.GLOBAL_ATTRIBUTE15
, PL.GLOBAL_ATTRIBUTE16
, PL.GLOBAL_ATTRIBUTE17
, PL.GLOBAL_ATTRIBUTE18
, PL.GLOBAL_ATTRIBUTE19
, PL.GLOBAL_ATTRIBUTE20
, PL.LINE_REFERENCE_NUM
, PL.PROJECT_ID
, PL.TASK_ID
, PL.EXPIRATION_DATE
, PL.TAX_CODE_ID
, PL.OKE_CONTRACT_HEADER_ID
, PL.OKE_CONTRACT_VERSION_ID
, PL.TAX_NAME
, PL.SECONDARY_UNIT_OF_MEASURE
, PL.SECONDARY_QUANTITY
, PL.PREFERRED_GRADE
, PL.AUCTION_HEADER_ID
, PL.AUCTION_DISPLAY_NUMBER
, PL.AUCTION_LINE_NUMBER
, PL.BID_NUMBER
, PL.BID_LINE_NUMBER
, PL.RETROACTIVE_DATE
, PL.SUPPLIER_REF_NUMBER
, PL.CONTRACT_ID
, PL.JOB_ID
, PL.AMOUNT
, PL.START_DATE
, PL.CONTRACTOR_FIRST_NAME
, PL.CONTRACTOR_LAST_NAME
, PL.ORDER_TYPE_LOOKUP_CODE
, PL.PURCHASE_BASIS
, PL.MATCHING_BASIS
, PL.SVC_AMOUNT_NOTIF_SENT
, PL.SVC_COMPLETION_NOTIF_SENT
, PL.FROM_LINE_LOCATION_ID
, PL.BASE_UNIT_PRICE
, PL.MANUAL_PRICE_CHANGE_FLAG
, PL.RETAINAGE_RATE
, PL.MAX_RETAINAGE_AMOUNT
, PL.PROGRESS_PAYMENT_RATE
, PL.RECOUPMENT_RATE
, PL.SUPPLIER_PART_AUXID
, PL.IP_CATEGORY_ID
, PL.TAX_ATTRIBUTE_UPDATE_CODE
, PL.CATALOG_NAME
FROM PO_LINES_ALL PL
WHERE NOT EXISTS ( SELECT 1
FROM PO_LINES_DRAFT_ALL PLD1
, PO_DRAFTS DFT1
WHERE PL.PO_LINE_ID = PLD1.PO_LINE_ID
AND PLD1.DRAFT_ID = DFT1.DRAFT_ID
AND DFT1.OWNER_ROLE = PO_GLOBAL.ROLE
AND DFT1.STATUS <> 'COMPLETED' )