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 ,PLD.GROUP_LINE_ID ,PLD.LINE_NUM_DISPLAY ,PLD.CLM_INFO_FLAG ,PLD.CLM_OPTION_INDICATOR ,PLD.CLM_BASE_LINE_NUM ,PLD.CLM_OPTION_NUM ,PLD.CLM_OPTION_FROM_DATE ,PLD.CLM_OPTION_TO_DATE ,PLD.CLM_FUNDED_FLAG ,PLD.CONTRACT_TYPE ,PLD.COST_CONSTRAINT ,PLD.CLM_IDC_TYPE ,pld.user_document_status, pld.control_action, pld.change_status, pld.uda_template_id, pld.clm_min_total_amount, pld.clm_max_total_amount, pld.clm_min_total_quantity, pld.clm_max_total_quantity, pld.clm_min_order_amount, pld.clm_max_order_amount, pld.clm_min_order_quantity, pld.clm_max_order_quantity, pld.clm_total_amount_ordered, pld.clm_total_quantity_ordered, pld.clm_fsc_psc, pld.clm_mdaps_mais, pld.clm_naics, pld.clm_order_start_date, pld.clm_order_end_date, pld.clm_exercised_flag, pld.clm_exercised_date, pld.old_quantity, pld.clm_exhibit_name, pld.old_uom_lookup_code, pld.clm_undef_action_code, pld.old_amount, pld.draft_line_status, pld.comments, pld.mod_draft_id, pld.clm_delivery_event_code, pld.clm_payment_instr_code , pld.clm_undef_flag , pld.clm_approved_undef_amount , pld.clm_uda_pricing_total , pld.old_unit_price , pld.clm_pop_exception_reason, pld.mod_line_id FROM po_lines_draft_all pld, po_drafts dft WHERE pld.draft_id = dft.draft_id AND Nvl(pld.delete_flag,'N') = 'N' UNION ALL SELECT To_number(NULL), NULL, NULL, To_number(-1), 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, pl.group_line_id, pl.line_num_display, pl.clm_info_flag, pl.clm_option_indicator, pl.clm_base_line_num, pl.clm_option_num, pl.clm_option_from_date, pl.clm_option_to_date, pl.clm_funded_flag, pl.contract_type, pl.cost_constraint, pl.clm_idc_type, NULL, NULL, NULL, pl.uda_template_id, pl.clm_min_total_amount, pl.clm_max_total_amount, pl.clm_min_total_quantity, pl.clm_max_total_quantity, pl.clm_min_order_amount, pl.clm_max_order_amount, pl.clm_min_order_quantity, pl.clm_max_order_quantity, pl.clm_total_amount_ordered, pl.clm_total_quantity_ordered, pl.clm_fsc_psc, pl.clm_mdaps_mais, pl.clm_naics, pl.clm_order_start_date, pl.clm_order_end_date, pl.clm_exercised_flag, pl.clm_exercised_date, pl.quantity, pl.clm_exhibit_name, pl.unit_meas_lookup_code, pl.clm_undef_action_code, pl.amount, NULL, NULL, NULL, pl.clm_delivery_event_code, pl.clm_payment_instr_code, pl.clm_undef_flag, pl.clm_approved_undef_amount, pl.clm_uda_pricing_total, pl.unit_price, pl.clm_pop_exception_reason, NULL FROM po_lines_all pl UNION ALL SELECT To_number(NULL), NULL, NULL, dft.draft_id, 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, pl.group_line_id, pl.line_num_display, pl.clm_info_flag, pl.clm_option_indicator, pl.clm_base_line_num, pl.clm_option_num, pl.clm_option_from_date, pl.clm_option_to_date, pl.clm_funded_flag, pl.contract_type, pl.cost_constraint, pl.clm_idc_type, NULL, NULL, NULL, pl.uda_template_id, pl.clm_min_total_amount, pl.clm_max_total_amount, pl.clm_min_total_quantity, pl.clm_max_total_quantity, pl.clm_min_order_amount, pl.clm_max_order_amount, pl.clm_min_order_quantity, pl.clm_max_order_quantity, pl.clm_total_amount_ordered, pl.clm_total_quantity_ordered, pl.clm_fsc_psc, pl.clm_mdaps_mais, pl.clm_naics, pl.clm_order_start_date, pl.clm_order_end_date, pl.clm_exercised_flag, pl.clm_exercised_date, pl.quantity, pl.clm_exhibit_name, pl.unit_meas_lookup_code, NULL, pl.amount, NULL, NULL, NULL, pl.clm_delivery_event_code, pl.clm_payment_instr_code, pl.clm_undef_flag, pl.clm_approved_undef_amount, pl.clm_uda_pricing_total, pl.unit_price, pl.clm_pop_exception_reason, NULL FROM po_lines_all pl, po_drafts dft WHERE pl.po_header_id = dft.document_id AND NOT EXISTS (SELECT 'Draft Exists For This Line' FROM po_lines_draft_all pld WHERE pl.po_line_id = pld.po_line_id AND pld.draft_id = dft.draft_id AND Nvl(pld.delete_flag,'N') = 'N')

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
, PLD.GROUP_LINE_ID
, PLD.LINE_NUM_DISPLAY
, PLD.CLM_INFO_FLAG
, PLD.CLM_OPTION_INDICATOR
, PLD.CLM_BASE_LINE_NUM
, PLD.CLM_OPTION_NUM
, PLD.CLM_OPTION_FROM_DATE
, PLD.CLM_OPTION_TO_DATE
, PLD.CLM_FUNDED_FLAG
, PLD.CONTRACT_TYPE
, PLD.COST_CONSTRAINT
, PLD.CLM_IDC_TYPE
, PLD.USER_DOCUMENT_STATUS
, PLD.CONTROL_ACTION
, PLD.CHANGE_STATUS
, PLD.UDA_TEMPLATE_ID
, PLD.CLM_MIN_TOTAL_AMOUNT
, PLD.CLM_MAX_TOTAL_AMOUNT
, PLD.CLM_MIN_TOTAL_QUANTITY
, PLD.CLM_MAX_TOTAL_QUANTITY
, PLD.CLM_MIN_ORDER_AMOUNT
, PLD.CLM_MAX_ORDER_AMOUNT
, PLD.CLM_MIN_ORDER_QUANTITY
, PLD.CLM_MAX_ORDER_QUANTITY
, PLD.CLM_TOTAL_AMOUNT_ORDERED
, PLD.CLM_TOTAL_QUANTITY_ORDERED
, PLD.CLM_FSC_PSC
, PLD.CLM_MDAPS_MAIS
, PLD.CLM_NAICS
, PLD.CLM_ORDER_START_DATE
, PLD.CLM_ORDER_END_DATE
, PLD.CLM_EXERCISED_FLAG
, PLD.CLM_EXERCISED_DATE
, PLD.OLD_QUANTITY
, PLD.CLM_EXHIBIT_NAME
, PLD.OLD_UOM_LOOKUP_CODE
, PLD.CLM_UNDEF_ACTION_CODE
, PLD.OLD_AMOUNT
, PLD.DRAFT_LINE_STATUS
, PLD.COMMENTS
, PLD.MOD_DRAFT_ID
, PLD.CLM_DELIVERY_EVENT_CODE
, PLD.CLM_PAYMENT_INSTR_CODE
, PLD.CLM_UNDEF_FLAG
, PLD.CLM_APPROVED_UNDEF_AMOUNT
, PLD.CLM_UDA_PRICING_TOTAL
, PLD.OLD_UNIT_PRICE
, PLD.CLM_POP_EXCEPTION_REASON
, PLD.MOD_LINE_ID
FROM PO_LINES_DRAFT_ALL PLD
, PO_DRAFTS DFT
WHERE PLD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PLD.DELETE_FLAG
, 'N') = 'N' UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(-1)
, 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
, PL.GROUP_LINE_ID
, PL.LINE_NUM_DISPLAY
, PL.CLM_INFO_FLAG
, PL.CLM_OPTION_INDICATOR
, PL.CLM_BASE_LINE_NUM
, PL.CLM_OPTION_NUM
, PL.CLM_OPTION_FROM_DATE
, PL.CLM_OPTION_TO_DATE
, PL.CLM_FUNDED_FLAG
, PL.CONTRACT_TYPE
, PL.COST_CONSTRAINT
, PL.CLM_IDC_TYPE
, NULL
, NULL
, NULL
, PL.UDA_TEMPLATE_ID
, PL.CLM_MIN_TOTAL_AMOUNT
, PL.CLM_MAX_TOTAL_AMOUNT
, PL.CLM_MIN_TOTAL_QUANTITY
, PL.CLM_MAX_TOTAL_QUANTITY
, PL.CLM_MIN_ORDER_AMOUNT
, PL.CLM_MAX_ORDER_AMOUNT
, PL.CLM_MIN_ORDER_QUANTITY
, PL.CLM_MAX_ORDER_QUANTITY
, PL.CLM_TOTAL_AMOUNT_ORDERED
, PL.CLM_TOTAL_QUANTITY_ORDERED
, PL.CLM_FSC_PSC
, PL.CLM_MDAPS_MAIS
, PL.CLM_NAICS
, PL.CLM_ORDER_START_DATE
, PL.CLM_ORDER_END_DATE
, PL.CLM_EXERCISED_FLAG
, PL.CLM_EXERCISED_DATE
, PL.QUANTITY
, PL.CLM_EXHIBIT_NAME
, PL.UNIT_MEAS_LOOKUP_CODE
, PL.CLM_UNDEF_ACTION_CODE
, PL.AMOUNT
, NULL
, NULL
, NULL
, PL.CLM_DELIVERY_EVENT_CODE
, PL.CLM_PAYMENT_INSTR_CODE
, PL.CLM_UNDEF_FLAG
, PL.CLM_APPROVED_UNDEF_AMOUNT
, PL.CLM_UDA_PRICING_TOTAL
, PL.UNIT_PRICE
, PL.CLM_POP_EXCEPTION_REASON
, NULL
FROM PO_LINES_ALL PL UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, DFT.DRAFT_ID
, 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
, PL.GROUP_LINE_ID
, PL.LINE_NUM_DISPLAY
, PL.CLM_INFO_FLAG
, PL.CLM_OPTION_INDICATOR
, PL.CLM_BASE_LINE_NUM
, PL.CLM_OPTION_NUM
, PL.CLM_OPTION_FROM_DATE
, PL.CLM_OPTION_TO_DATE
, PL.CLM_FUNDED_FLAG
, PL.CONTRACT_TYPE
, PL.COST_CONSTRAINT
, PL.CLM_IDC_TYPE
, NULL
, NULL
, NULL
, PL.UDA_TEMPLATE_ID
, PL.CLM_MIN_TOTAL_AMOUNT
, PL.CLM_MAX_TOTAL_AMOUNT
, PL.CLM_MIN_TOTAL_QUANTITY
, PL.CLM_MAX_TOTAL_QUANTITY
, PL.CLM_MIN_ORDER_AMOUNT
, PL.CLM_MAX_ORDER_AMOUNT
, PL.CLM_MIN_ORDER_QUANTITY
, PL.CLM_MAX_ORDER_QUANTITY
, PL.CLM_TOTAL_AMOUNT_ORDERED
, PL.CLM_TOTAL_QUANTITY_ORDERED
, PL.CLM_FSC_PSC
, PL.CLM_MDAPS_MAIS
, PL.CLM_NAICS
, PL.CLM_ORDER_START_DATE
, PL.CLM_ORDER_END_DATE
, PL.CLM_EXERCISED_FLAG
, PL.CLM_EXERCISED_DATE
, PL.QUANTITY
, PL.CLM_EXHIBIT_NAME
, PL.UNIT_MEAS_LOOKUP_CODE
, NULL
, PL.AMOUNT
, NULL
, NULL
, NULL
, PL.CLM_DELIVERY_EVENT_CODE
, PL.CLM_PAYMENT_INSTR_CODE
, PL.CLM_UNDEF_FLAG
, PL.CLM_APPROVED_UNDEF_AMOUNT
, PL.CLM_UDA_PRICING_TOTAL
, PL.UNIT_PRICE
, PL.CLM_POP_EXCEPTION_REASON
, NULL
FROM PO_LINES_ALL PL
, PO_DRAFTS DFT
WHERE PL.PO_HEADER_ID = DFT.DOCUMENT_ID
AND NOT EXISTS (SELECT 'DRAFT EXISTS FOR THIS LINE'
FROM PO_LINES_DRAFT_ALL PLD
WHERE PL.PO_LINE_ID = PLD.PO_LINE_ID
AND PLD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PLD.DELETE_FLAG
, 'N') = 'N')