VIEW: APPS.PO_LINES_DIFF_V

Source

View Text - Preformatted

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