VIEW: APPS.PO_LINES_DRAFT_DIFF_V

Source

View Text - Preformatted

SELECT po_header_id pk1_value, draft_id pk2_value, pl_po_line_id pk3_value, null pk4_value, null pk5_value, col_name , col_value, revision_num FROM ( SELECT pld.po_header_id, pld.draft_id, pld.po_line_id pl_po_line_id, pld.clm_exhibit_name, to_char(pld.line_type_id) line_type_id, to_char(pld.line_num) line_num, to_char(pld.item_id) item_id, pld.item_revision, to_char(pld.category_id) category_id, pld.item_description, decode(pld.order_type_lookup_code, 'QUANTITY', pld.unit_meas_lookup_code, null) unit_meas_lookup_code, to_char(pld.quantity_committed) quantity_committed, to_char(pld.committed_amount) committed_amount, pld.allow_price_override_flag, to_char(pld.not_to_exceed_price) not_to_exceed_price, to_char(decode(pld.order_type_lookup_code, 'QUANTITY', pld.list_price_per_unit, null)) list_price_per_unit, to_char(decode(pld.order_type_lookup_code, 'QUANTITY', pld.unit_price, null)) unit_price, to_char(decode(pld.order_type_lookup_code, 'QUANTITY', pld.quantity, null)) quantity, to_char(pld.un_number_id) un_number_id, to_char(pld.hazard_class_id) hazard_class_id, pld.note_to_vendor, to_char(pld.from_header_id) from_header_id, to_char(pld.from_line_id) from_line_id, to_char(pld.min_order_quantity) min_order_quantity, to_char(pld.max_order_quantity) max_order_quantity, to_char(pld.qty_rcv_tolerance) qty_rcv_tolerance, pld.over_tolerance_error_flag, to_char(pld.market_price) market_price, pld.unordered_flag, pld.user_hold_flag, pld.cancel_flag, to_char(pld.cancelled_by) cancelled_by, to_char(pld.cancel_date) cancel_date, pld.cancel_reason, pld.firm_status_lookup_code, to_char(pld.firm_date) firm_date, pld.vendor_product_num, pld.contract_num, pld.taxable_flag, pld.tax_name, 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.attribute9, pld.attribute10, pld.reference_num, pld.attribute11, pld.attribute12, pld.attribute13, pld.attribute14, pld.attribute15, to_char(pld.min_release_amount) min_release_amount, pld.price_type_lookup_code, to_char(pld.revision_num) revision_num, pld.price_break_lookup_code, pld.ussgl_transaction_code, pld.government_context, to_char(pld.request_id) request_id, to_char(pld.program_application_id) program_application_id, to_char(pld.program_id) program_id, to_char(pld.program_update_date) program_update_date, pld.closed_code, to_char(pld.closed_by) closed_by, to_char(pld.closed_date) closed_date, pld.closed_reason, pld.transaction_reason_code, to_char(pld.org_id) org_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_attribute15, pld.global_attribute16, pld.global_attribute17, pld.global_attribute18, pld.global_attribute19, pld.global_attribute20, to_char(pld.expiration_date) expiration_date, pld.qc_grade, pld.base_uom, to_char(pld.base_qty) base_qty, pld.secondary_uom, to_char(pld.secondary_qty) secondary_qty, pld.line_reference_num, to_char(pld.project_id) project_id, to_char(pld.task_id) task_id, to_char(pld.tax_code_id) tax_code_id, pld.secondary_unit_of_measure, to_char(pld.secondary_quantity) secondary_quantity, pld.preferred_grade, to_char(pld.clm_option_from_date) clm_option_from_date, to_char(pld.clm_option_to_date) clm_option_to_date, pld.clm_funded_flag, pld.contract_type, pld.cost_constraint, pld.clm_idc_type, pld.user_document_status, pld.clm_exercised_flag, to_char(pld.clm_exercised_date) clm_exercised_date, to_char(pld.group_line_id) group_line_id, pld.line_num_display, pld.clm_info_flag, pld.clm_option_indicator, to_char(pld.clm_base_line_num) clm_base_line_num, to_char(pld.clm_option_num) clm_option_num, pld.clm_delivery_event_code, pld.clm_payment_instr_code, pld.clm_undef_flag, pld.clm_undef_action_code, to_char(pld.clm_approved_undef_amount) clm_approved_undef_amount, to_char(pld.clm_uda_pricing_total) clm_uda_pricing_total, pld.clm_pop_exception_reason, pld.closed_flag, pld.global_attribute14, to_char(pld.oke_contract_header_id) oke_contract_header_id, to_char(pld.oke_contract_version_id) oke_contract_version_id, to_char(pld.retroactive_date) retroactive_date, pld.supplier_ref_number, to_char(pld.contract_id) contract_id, to_char(pld.job_id) job_id, to_char(decode(pld.order_type_lookup_code, 'QUANTITY', pld.amount, null)) amount, to_char(pld.start_date) 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, to_char(pld.base_unit_price) base_unit_price, pld.manual_price_change_flag, to_char(pld.retainage_rate) retainage_rate, to_char(pld.max_retainage_amount) max_retainage_amount, to_char(pld.progress_payment_rate) progress_payment_rate, to_char(pld.recoupment_rate) recoupment_rate, pld.catalog_name, pld.supplier_part_auxid, to_char(pld.ip_category_id) ip_category_id, to_char(pld.auction_header_id) auction_header_id, pld.auction_display_number, to_char(pld.auction_line_number) auction_line_number, to_char(pld.bid_number) bid_number, to_char(pld.bid_line_number) bid_line_number, pld.clm_fsc_psc, to_char(pld.clm_max_order_amount) clm_max_order_amount, to_char(pld.clm_max_order_quantity) clm_max_order_quantity, to_char(pld.clm_max_total_amount) clm_max_total_amount, to_char(pld.clm_max_total_quantity) clm_max_total_quantity, pld.clm_mdaps_mais, to_char(pld.clm_min_order_amount) clm_min_order_amount, to_char(pld.clm_min_order_quantity) clm_min_order_quantity, to_char(pld.clm_min_total_amount) clm_min_total_amount, to_char(pld.clm_min_total_quantity) clm_min_total_quantity, pld.clm_naics, to_char(pld.clm_order_end_date) clm_order_end_date, to_char(pld.clm_order_start_date) clm_order_start_date, to_char(pld.clm_total_amount_ordered) clm_total_amount_ordered, to_char(pld.clm_total_quantity_ordered) clm_total_quantity_ordered, to_char(pld.from_line_location_id) from_line_location_id, pld.tax_attribute_update_code, to_char(pld.uda_template_id) uda_template_id, null as change_status FROM po_lines_draft_all pld WHERE change_status = 'UPDATE' AND po_header_id = PO_GEN_DIFF_PKG.getModPK1 AND draft_id = PO_GEN_DIFF_PKG.getModPK2) po_line_unpivot_data unpivot include nulls ( col_value for col_name in ( CLM_EXHIBIT_NAME, LINE_TYPE_ID, LINE_NUM, ITEM_ID, ITEM_REVISION, CATEGORY_ID, ITEM_DESCRIPTION, UNIT_MEAS_LOOKUP_CODE, QUANTITY_COMMITTED, COMMITTED_AMOUNT, ALLOW_PRICE_OVERRIDE_FLAG, NOT_TO_EXCEED_PRICE, LIST_PRICE_PER_UNIT, UNIT_PRICE, QUANTITY, UN_NUMBER_ID, HAZARD_CLASS_ID, NOTE_TO_VENDOR, FROM_HEADER_ID, FROM_LINE_ID, MIN_ORDER_QUANTITY, MAX_ORDER_QUANTITY, QTY_RCV_TOLERANCE, OVER_TOLERANCE_ERROR_FLAG, MARKET_PRICE, UNORDERED_FLAG, USER_HOLD_FLAG, CANCEL_FLAG, CANCELLED_BY, CANCEL_DATE, CANCEL_REASON, FIRM_STATUS_LOOKUP_CODE, FIRM_DATE, VENDOR_PRODUCT_NUM, CONTRACT_NUM, TAXABLE_FLAG, TAX_NAME, TYPE_1099, CAPITAL_EXPENSE_FLAG, NEGOTIATED_BY_PREPARER_FLAG, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, REFERENCE_NUM, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, MIN_RELEASE_AMOUNT, PRICE_TYPE_LOOKUP_CODE, PRICE_BREAK_LOOKUP_CODE, USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CLOSED_CODE, CLOSED_BY, CLOSED_DATE, CLOSED_REASON, TRANSACTION_REASON_CODE, ORG_ID, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20, EXPIRATION_DATE, QC_GRADE, BASE_UOM, BASE_QTY, SECONDARY_UOM, SECONDARY_QTY, LINE_REFERENCE_NUM, PROJECT_ID, TASK_ID, TAX_CODE_ID, SECONDARY_UNIT_OF_MEASURE, SECONDARY_QUANTITY, PREFERRED_GRADE, CLM_OPTION_FROM_DATE, CLM_OPTION_TO_DATE, CLM_FUNDED_FLAG, CONTRACT_TYPE, COST_CONSTRAINT, CLM_IDC_TYPE, USER_DOCUMENT_STATUS, CLM_EXERCISED_FLAG, CLM_EXERCISED_DATE, GROUP_LINE_ID, LINE_NUM_DISPLAY, CLM_INFO_FLAG, CLM_OPTION_INDICATOR, CLM_BASE_LINE_NUM, CLM_OPTION_NUM, CLM_DELIVERY_EVENT_CODE, CLM_PAYMENT_INSTR_CODE, CLM_UNDEF_FLAG, CLM_UNDEF_ACTION_CODE, CLM_APPROVED_UNDEF_AMOUNT, CLM_UDA_PRICING_TOTAL, CLM_POP_EXCEPTION_REASON, CLOSED_FLAG, GLOBAL_ATTRIBUTE14, OKE_CONTRACT_HEADER_ID, OKE_CONTRACT_VERSION_ID, RETROACTIVE_DATE, SUPPLIER_REF_NUMBER, CONTRACT_ID, JOB_ID, AMOUNT, START_DATE, CONTRACTOR_FIRST_NAME, CONTRACTOR_LAST_NAME, ORDER_TYPE_LOOKUP_CODE, PURCHASE_BASIS, MATCHING_BASIS, SVC_AMOUNT_NOTIF_SENT, SVC_COMPLETION_NOTIF_SENT, BASE_UNIT_PRICE, MANUAL_PRICE_CHANGE_FLAG, RETAINAGE_RATE, MAX_RETAINAGE_AMOUNT, PROGRESS_PAYMENT_RATE, RECOUPMENT_RATE, CATALOG_NAME, SUPPLIER_PART_AUXID, IP_CATEGORY_ID, AUCTION_HEADER_ID, AUCTION_DISPLAY_NUMBER, AUCTION_LINE_NUMBER, BID_NUMBER, BID_LINE_NUMBER, CLM_FSC_PSC, CLM_MAX_ORDER_AMOUNT, CLM_MAX_ORDER_QUANTITY, CLM_MAX_TOTAL_AMOUNT, CLM_MAX_TOTAL_QUANTITY, CLM_MDAPS_MAIS, CLM_MIN_ORDER_AMOUNT, CLM_MIN_ORDER_QUANTITY, CLM_MIN_TOTAL_AMOUNT, CLM_MIN_TOTAL_QUANTITY, CLM_NAICS, CLM_ORDER_END_DATE, CLM_ORDER_START_DATE, CLM_TOTAL_AMOUNT_ORDERED, CLM_TOTAL_QUANTITY_ORDERED, FROM_LINE_LOCATION_ID, TAX_ATTRIBUTE_UPDATE_CODE, UDA_TEMPLATE_ID, CHANGE_STATUS) )

View Text - HTML Formatted

SELECT PO_HEADER_ID PK1_VALUE
, DRAFT_ID PK2_VALUE
, PL_PO_LINE_ID PK3_VALUE
, NULL PK4_VALUE
, NULL PK5_VALUE
, COL_NAME
, COL_VALUE
, REVISION_NUM
FROM ( SELECT PLD.PO_HEADER_ID
, PLD.DRAFT_ID
, PLD.PO_LINE_ID PL_PO_LINE_ID
, PLD.CLM_EXHIBIT_NAME
, TO_CHAR(PLD.LINE_TYPE_ID) LINE_TYPE_ID
, TO_CHAR(PLD.LINE_NUM) LINE_NUM
, TO_CHAR(PLD.ITEM_ID) ITEM_ID
, PLD.ITEM_REVISION
, TO_CHAR(PLD.CATEGORY_ID) CATEGORY_ID
, PLD.ITEM_DESCRIPTION
, DECODE(PLD.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, PLD.UNIT_MEAS_LOOKUP_CODE
, NULL) UNIT_MEAS_LOOKUP_CODE
, TO_CHAR(PLD.QUANTITY_COMMITTED) QUANTITY_COMMITTED
, TO_CHAR(PLD.COMMITTED_AMOUNT) COMMITTED_AMOUNT
, PLD.ALLOW_PRICE_OVERRIDE_FLAG
, TO_CHAR(PLD.NOT_TO_EXCEED_PRICE) NOT_TO_EXCEED_PRICE
, TO_CHAR(DECODE(PLD.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, PLD.LIST_PRICE_PER_UNIT
, NULL)) LIST_PRICE_PER_UNIT
, TO_CHAR(DECODE(PLD.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, PLD.UNIT_PRICE
, NULL)) UNIT_PRICE
, TO_CHAR(DECODE(PLD.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, PLD.QUANTITY
, NULL)) QUANTITY
, TO_CHAR(PLD.UN_NUMBER_ID) UN_NUMBER_ID
, TO_CHAR(PLD.HAZARD_CLASS_ID) HAZARD_CLASS_ID
, PLD.NOTE_TO_VENDOR
, TO_CHAR(PLD.FROM_HEADER_ID) FROM_HEADER_ID
, TO_CHAR(PLD.FROM_LINE_ID) FROM_LINE_ID
, TO_CHAR(PLD.MIN_ORDER_QUANTITY) MIN_ORDER_QUANTITY
, TO_CHAR(PLD.MAX_ORDER_QUANTITY) MAX_ORDER_QUANTITY
, TO_CHAR(PLD.QTY_RCV_TOLERANCE) QTY_RCV_TOLERANCE
, PLD.OVER_TOLERANCE_ERROR_FLAG
, TO_CHAR(PLD.MARKET_PRICE) MARKET_PRICE
, PLD.UNORDERED_FLAG
, PLD.USER_HOLD_FLAG
, PLD.CANCEL_FLAG
, TO_CHAR(PLD.CANCELLED_BY) CANCELLED_BY
, TO_CHAR(PLD.CANCEL_DATE) CANCEL_DATE
, PLD.CANCEL_REASON
, PLD.FIRM_STATUS_LOOKUP_CODE
, TO_CHAR(PLD.FIRM_DATE) FIRM_DATE
, PLD.VENDOR_PRODUCT_NUM
, PLD.CONTRACT_NUM
, PLD.TAXABLE_FLAG
, PLD.TAX_NAME
, 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.ATTRIBUTE9
, PLD.ATTRIBUTE10
, PLD.REFERENCE_NUM
, PLD.ATTRIBUTE11
, PLD.ATTRIBUTE12
, PLD.ATTRIBUTE13
, PLD.ATTRIBUTE14
, PLD.ATTRIBUTE15
, TO_CHAR(PLD.MIN_RELEASE_AMOUNT) MIN_RELEASE_AMOUNT
, PLD.PRICE_TYPE_LOOKUP_CODE
, TO_CHAR(PLD.REVISION_NUM) REVISION_NUM
, PLD.PRICE_BREAK_LOOKUP_CODE
, PLD.USSGL_TRANSACTION_CODE
, PLD.GOVERNMENT_CONTEXT
, TO_CHAR(PLD.REQUEST_ID) REQUEST_ID
, TO_CHAR(PLD.PROGRAM_APPLICATION_ID) PROGRAM_APPLICATION_ID
, TO_CHAR(PLD.PROGRAM_ID) PROGRAM_ID
, TO_CHAR(PLD.PROGRAM_UPDATE_DATE) PROGRAM_UPDATE_DATE
, PLD.CLOSED_CODE
, TO_CHAR(PLD.CLOSED_BY) CLOSED_BY
, TO_CHAR(PLD.CLOSED_DATE) CLOSED_DATE
, PLD.CLOSED_REASON
, PLD.TRANSACTION_REASON_CODE
, TO_CHAR(PLD.ORG_ID) ORG_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_ATTRIBUTE15
, PLD.GLOBAL_ATTRIBUTE16
, PLD.GLOBAL_ATTRIBUTE17
, PLD.GLOBAL_ATTRIBUTE18
, PLD.GLOBAL_ATTRIBUTE19
, PLD.GLOBAL_ATTRIBUTE20
, TO_CHAR(PLD.EXPIRATION_DATE) EXPIRATION_DATE
, PLD.QC_GRADE
, PLD.BASE_UOM
, TO_CHAR(PLD.BASE_QTY) BASE_QTY
, PLD.SECONDARY_UOM
, TO_CHAR(PLD.SECONDARY_QTY) SECONDARY_QTY
, PLD.LINE_REFERENCE_NUM
, TO_CHAR(PLD.PROJECT_ID) PROJECT_ID
, TO_CHAR(PLD.TASK_ID) TASK_ID
, TO_CHAR(PLD.TAX_CODE_ID) TAX_CODE_ID
, PLD.SECONDARY_UNIT_OF_MEASURE
, TO_CHAR(PLD.SECONDARY_QUANTITY) SECONDARY_QUANTITY
, PLD.PREFERRED_GRADE
, TO_CHAR(PLD.CLM_OPTION_FROM_DATE) CLM_OPTION_FROM_DATE
, TO_CHAR(PLD.CLM_OPTION_TO_DATE) CLM_OPTION_TO_DATE
, PLD.CLM_FUNDED_FLAG
, PLD.CONTRACT_TYPE
, PLD.COST_CONSTRAINT
, PLD.CLM_IDC_TYPE
, PLD.USER_DOCUMENT_STATUS
, PLD.CLM_EXERCISED_FLAG
, TO_CHAR(PLD.CLM_EXERCISED_DATE) CLM_EXERCISED_DATE
, TO_CHAR(PLD.GROUP_LINE_ID) GROUP_LINE_ID
, PLD.LINE_NUM_DISPLAY
, PLD.CLM_INFO_FLAG
, PLD.CLM_OPTION_INDICATOR
, TO_CHAR(PLD.CLM_BASE_LINE_NUM) CLM_BASE_LINE_NUM
, TO_CHAR(PLD.CLM_OPTION_NUM) CLM_OPTION_NUM
, PLD.CLM_DELIVERY_EVENT_CODE
, PLD.CLM_PAYMENT_INSTR_CODE
, PLD.CLM_UNDEF_FLAG
, PLD.CLM_UNDEF_ACTION_CODE
, TO_CHAR(PLD.CLM_APPROVED_UNDEF_AMOUNT) CLM_APPROVED_UNDEF_AMOUNT
, TO_CHAR(PLD.CLM_UDA_PRICING_TOTAL) CLM_UDA_PRICING_TOTAL
, PLD.CLM_POP_EXCEPTION_REASON
, PLD.CLOSED_FLAG
, PLD.GLOBAL_ATTRIBUTE14
, TO_CHAR(PLD.OKE_CONTRACT_HEADER_ID) OKE_CONTRACT_HEADER_ID
, TO_CHAR(PLD.OKE_CONTRACT_VERSION_ID) OKE_CONTRACT_VERSION_ID
, TO_CHAR(PLD.RETROACTIVE_DATE) RETROACTIVE_DATE
, PLD.SUPPLIER_REF_NUMBER
, TO_CHAR(PLD.CONTRACT_ID) CONTRACT_ID
, TO_CHAR(PLD.JOB_ID) JOB_ID
, TO_CHAR(DECODE(PLD.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, PLD.AMOUNT
, NULL)) AMOUNT
, TO_CHAR(PLD.START_DATE) 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
, TO_CHAR(PLD.BASE_UNIT_PRICE) BASE_UNIT_PRICE
, PLD.MANUAL_PRICE_CHANGE_FLAG
, TO_CHAR(PLD.RETAINAGE_RATE) RETAINAGE_RATE
, TO_CHAR(PLD.MAX_RETAINAGE_AMOUNT) MAX_RETAINAGE_AMOUNT
, TO_CHAR(PLD.PROGRESS_PAYMENT_RATE) PROGRESS_PAYMENT_RATE
, TO_CHAR(PLD.RECOUPMENT_RATE) RECOUPMENT_RATE
, PLD.CATALOG_NAME
, PLD.SUPPLIER_PART_AUXID
, TO_CHAR(PLD.IP_CATEGORY_ID) IP_CATEGORY_ID
, TO_CHAR(PLD.AUCTION_HEADER_ID) AUCTION_HEADER_ID
, PLD.AUCTION_DISPLAY_NUMBER
, TO_CHAR(PLD.AUCTION_LINE_NUMBER) AUCTION_LINE_NUMBER
, TO_CHAR(PLD.BID_NUMBER) BID_NUMBER
, TO_CHAR(PLD.BID_LINE_NUMBER) BID_LINE_NUMBER
, PLD.CLM_FSC_PSC
, TO_CHAR(PLD.CLM_MAX_ORDER_AMOUNT) CLM_MAX_ORDER_AMOUNT
, TO_CHAR(PLD.CLM_MAX_ORDER_QUANTITY) CLM_MAX_ORDER_QUANTITY
, TO_CHAR(PLD.CLM_MAX_TOTAL_AMOUNT) CLM_MAX_TOTAL_AMOUNT
, TO_CHAR(PLD.CLM_MAX_TOTAL_QUANTITY) CLM_MAX_TOTAL_QUANTITY
, PLD.CLM_MDAPS_MAIS
, TO_CHAR(PLD.CLM_MIN_ORDER_AMOUNT) CLM_MIN_ORDER_AMOUNT
, TO_CHAR(PLD.CLM_MIN_ORDER_QUANTITY) CLM_MIN_ORDER_QUANTITY
, TO_CHAR(PLD.CLM_MIN_TOTAL_AMOUNT) CLM_MIN_TOTAL_AMOUNT
, TO_CHAR(PLD.CLM_MIN_TOTAL_QUANTITY) CLM_MIN_TOTAL_QUANTITY
, PLD.CLM_NAICS
, TO_CHAR(PLD.CLM_ORDER_END_DATE) CLM_ORDER_END_DATE
, TO_CHAR(PLD.CLM_ORDER_START_DATE) CLM_ORDER_START_DATE
, TO_CHAR(PLD.CLM_TOTAL_AMOUNT_ORDERED) CLM_TOTAL_AMOUNT_ORDERED
, TO_CHAR(PLD.CLM_TOTAL_QUANTITY_ORDERED) CLM_TOTAL_QUANTITY_ORDERED
, TO_CHAR(PLD.FROM_LINE_LOCATION_ID) FROM_LINE_LOCATION_ID
, PLD.TAX_ATTRIBUTE_UPDATE_CODE
, TO_CHAR(PLD.UDA_TEMPLATE_ID) UDA_TEMPLATE_ID
, NULL AS CHANGE_STATUS
FROM PO_LINES_DRAFT_ALL PLD
WHERE CHANGE_STATUS = 'UPDATE'
AND PO_HEADER_ID = PO_GEN_DIFF_PKG.GETMODPK1
AND DRAFT_ID = PO_GEN_DIFF_PKG.GETMODPK2) PO_LINE_UNPIVOT_DATA UNPIVOT INCLUDE NULLS ( COL_VALUE FOR COL_NAME IN ( CLM_EXHIBIT_NAME
, LINE_TYPE_ID
, LINE_NUM
, ITEM_ID
, ITEM_REVISION
, CATEGORY_ID
, ITEM_DESCRIPTION
, UNIT_MEAS_LOOKUP_CODE
, QUANTITY_COMMITTED
, COMMITTED_AMOUNT
, ALLOW_PRICE_OVERRIDE_FLAG
, NOT_TO_EXCEED_PRICE
, LIST_PRICE_PER_UNIT
, UNIT_PRICE
, QUANTITY
, UN_NUMBER_ID
, HAZARD_CLASS_ID
, NOTE_TO_VENDOR
, FROM_HEADER_ID
, FROM_LINE_ID
, MIN_ORDER_QUANTITY
, MAX_ORDER_QUANTITY
, QTY_RCV_TOLERANCE
, OVER_TOLERANCE_ERROR_FLAG
, MARKET_PRICE
, UNORDERED_FLAG
, USER_HOLD_FLAG
, CANCEL_FLAG
, CANCELLED_BY
, CANCEL_DATE
, CANCEL_REASON
, FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE
, VENDOR_PRODUCT_NUM
, CONTRACT_NUM
, TAXABLE_FLAG
, TAX_NAME
, TYPE_1099
, CAPITAL_EXPENSE_FLAG
, NEGOTIATED_BY_PREPARER_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, REFERENCE_NUM
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, MIN_RELEASE_AMOUNT
, PRICE_TYPE_LOOKUP_CODE
, PRICE_BREAK_LOOKUP_CODE
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CLOSED_CODE
, CLOSED_BY
, CLOSED_DATE
, CLOSED_REASON
, TRANSACTION_REASON_CODE
, ORG_ID
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, EXPIRATION_DATE
, QC_GRADE
, BASE_UOM
, BASE_QTY
, SECONDARY_UOM
, SECONDARY_QTY
, LINE_REFERENCE_NUM
, PROJECT_ID
, TASK_ID
, TAX_CODE_ID
, SECONDARY_UNIT_OF_MEASURE
, SECONDARY_QUANTITY
, PREFERRED_GRADE
, CLM_OPTION_FROM_DATE
, CLM_OPTION_TO_DATE
, CLM_FUNDED_FLAG
, CONTRACT_TYPE
, COST_CONSTRAINT
, CLM_IDC_TYPE
, USER_DOCUMENT_STATUS
, CLM_EXERCISED_FLAG
, CLM_EXERCISED_DATE
, GROUP_LINE_ID
, LINE_NUM_DISPLAY
, CLM_INFO_FLAG
, CLM_OPTION_INDICATOR
, CLM_BASE_LINE_NUM
, CLM_OPTION_NUM
, CLM_DELIVERY_EVENT_CODE
, CLM_PAYMENT_INSTR_CODE
, CLM_UNDEF_FLAG
, CLM_UNDEF_ACTION_CODE
, CLM_APPROVED_UNDEF_AMOUNT
, CLM_UDA_PRICING_TOTAL
, CLM_POP_EXCEPTION_REASON
, CLOSED_FLAG
, GLOBAL_ATTRIBUTE14
, OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_VERSION_ID
, RETROACTIVE_DATE
, SUPPLIER_REF_NUMBER
, CONTRACT_ID
, JOB_ID
, AMOUNT
, START_DATE
, CONTRACTOR_FIRST_NAME
, CONTRACTOR_LAST_NAME
, ORDER_TYPE_LOOKUP_CODE
, PURCHASE_BASIS
, MATCHING_BASIS
, SVC_AMOUNT_NOTIF_SENT
, SVC_COMPLETION_NOTIF_SENT
, BASE_UNIT_PRICE
, MANUAL_PRICE_CHANGE_FLAG
, RETAINAGE_RATE
, MAX_RETAINAGE_AMOUNT
, PROGRESS_PAYMENT_RATE
, RECOUPMENT_RATE
, CATALOG_NAME
, SUPPLIER_PART_AUXID
, IP_CATEGORY_ID
, AUCTION_HEADER_ID
, AUCTION_DISPLAY_NUMBER
, AUCTION_LINE_NUMBER
, BID_NUMBER
, BID_LINE_NUMBER
, CLM_FSC_PSC
, CLM_MAX_ORDER_AMOUNT
, CLM_MAX_ORDER_QUANTITY
, CLM_MAX_TOTAL_AMOUNT
, CLM_MAX_TOTAL_QUANTITY
, CLM_MDAPS_MAIS
, CLM_MIN_ORDER_AMOUNT
, CLM_MIN_ORDER_QUANTITY
, CLM_MIN_TOTAL_AMOUNT
, CLM_MIN_TOTAL_QUANTITY
, CLM_NAICS
, CLM_ORDER_END_DATE
, CLM_ORDER_START_DATE
, CLM_TOTAL_AMOUNT_ORDERED
, CLM_TOTAL_QUANTITY_ORDERED
, FROM_LINE_LOCATION_ID
, TAX_ATTRIBUTE_UPDATE_CODE
, UDA_TEMPLATE_ID
, CHANGE_STATUS) )