Product: | PO - Purchasing |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PO_LINES_MERGE_V |
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
FROM PO_LINES_DRAFT_ALL PLD
, PO_DRAFTS DFT
WHERE PLD.DRAFT_ID = DFT.DRAFT_ID
AND PLD.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
, 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
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' )