VIEW: APPS.PO_LINE_LOCS_DIFF_V

Source

View Text - Preformatted

SELECT po_header_id pk1_value, -1 pk2_value, po_line_id pk3_value, line_location_id pk4_value, null pk5_value, col_name , col_value, revision_num from ( SELECT pll.po_header_id, -1 draft_id, pll.po_line_id, pll.line_location_id, pll.accrue_on_receipt_flag, pll.allow_substitute_receipts_flag, to_char(pll.amount) amount, to_char(pll.amount_accepted) amount_accepted, to_char(pll.amount_billed) amount_billed, to_char(pll.amount_cancelled) amount_cancelled, to_char(pll.amount_financed) amount_financed, to_char(pll.amount_received) amount_received, to_char(pll.amount_recouped) amount_recouped, to_char(pll.amount_rejected) amount_rejected, to_char(pll.amount_shipped) amount_shipped, to_char(pll.approved_date) approved_date, pll.approved_flag, pll.attribute1, pll.attribute10, pll.attribute11, pll.attribute12, pll.attribute13, pll.attribute14, pll.attribute15, pll.attribute2, pll.attribute3, pll.attribute4, pll.attribute5, pll.attribute6, pll.attribute7, pll.attribute8, pll.attribute9, pll.attribute_category, to_char(pll.bid_payment_id) bid_payment_id, pll.calculate_tax_flag, to_char(pll.cancelled_by) cancelled_by, to_char(pll.cancel_date) cancel_date, pll.cancel_flag, pll.cancel_reason, pll.change_promised_date_reason, to_char(pll.clm_delivery_period) clm_delivery_period, pll.clm_delivery_period_uom, to_char(pll.clm_period_perf_end_date) clm_period_perf_end_date, to_char(pll.clm_period_perf_start_date) clm_period_perf_start_date, to_char(pll.clm_pop_duration) clm_pop_duration, pll.clm_pop_duration_uom, to_char(pll.clm_promise_period) clm_promise_period, pll.clm_promise_period_uom, to_char(pll.closed_by) closed_by, pll.closed_code, to_char(pll.closed_date) closed_date, pll.closed_flag, to_char(pll.closed_for_invoice_date) closed_for_invoice_date, to_char(pll.closed_for_receiving_date) closed_for_receiving_date, pll.closed_reason, pll.consigned_flag, pll.country_of_origin_code, to_char(pll.days_early_receipt_allowed) days_early_receipt_allowed, to_char(pll.days_late_receipt_allowed) days_late_receipt_allowed, pll.description, pll.drop_ship_flag, to_char(pll.encumbered_date) encumbered_date, pll.encumbered_flag, pll.encumber_now, to_char(pll.end_date) end_date, pll.enforce_ship_to_location_code, to_char(pll.estimated_tax_amount) estimated_tax_amount, pll.final_match_flag, to_char(pll.firm_date) firm_date, pll.firm_status_lookup_code, pll.fob_lookup_code, pll.freight_terms_lookup_code, to_char(pll.from_header_id) from_header_id, to_char(pll.from_line_id) from_line_id, to_char(pll.from_line_location_id) from_line_location_id, pll.global_attribute1, pll.global_attribute10, pll.global_attribute11, pll.global_attribute12, pll.global_attribute13, pll.global_attribute14, pll.global_attribute15, pll.global_attribute16, pll.global_attribute17, pll.global_attribute18, pll.global_attribute19, pll.global_attribute2, pll.global_attribute20, pll.global_attribute3, pll.global_attribute4, pll.global_attribute5, pll.global_attribute6, pll.global_attribute7, pll.global_attribute8, pll.global_attribute9, pll.global_attribute_category, pll.government_context, pll.inspection_required_flag, to_char(pll.invoice_close_tolerance) invoice_close_tolerance, to_char(pll.last_accept_date) last_accept_date, to_char(pll.lead_time) lead_time, pll.lead_time_unit, pll.manual_price_change_flag, pll.matching_basis, pll.match_option, to_char(pll.need_by_date) need_by_date, pll.note_to_receiver, to_char(pll.org_id) org_id, to_char(pll.outsourced_assembly) outsourced_assembly, pll.payment_type, to_char(pll.po_release_id) po_release_id, pll.preferred_grade, to_char(pll.price_discount) price_discount, to_char(pll.price_override) price_override, to_char(pll.program_application_id) program_application_id, to_char(pll.program_id) program_id, to_char(pll.program_update_date) program_update_date, to_char(pll.promised_date) promised_date, pll.qty_rcv_exception_code, to_char(pll.qty_rcv_tolerance) qty_rcv_tolerance, to_char(pll.quantity) quantity, to_char(pll.quantity_accepted) quantity_accepted, to_char(pll.quantity_billed) quantity_billed, to_char(pll.quantity_cancelled) quantity_cancelled, to_char(pll.quantity_financed) quantity_financed, to_char(pll.quantity_received) quantity_received, to_char(pll.quantity_recouped) quantity_recouped, to_char(pll.quantity_rejected) quantity_rejected, to_char(pll.quantity_shipped) quantity_shipped, pll.receipt_days_exception_code, pll.receipt_required_flag, to_char(pll.receive_close_tolerance) receive_close_tolerance, to_char(pll.receiving_routing_id) receiving_routing_id, to_char(pll.request_id) request_id, to_char(pll.retainage_released_amount) retainage_released_amount, to_char(pll.retainage_withheld_amount) retainage_withheld_amount, to_char(pll.retroactive_date) retroactive_date, to_char(pll.revision_num) revision_num, to_char(pll.sales_order_update_date) sales_order_update_date, to_char(pll.secondary_quantity) secondary_quantity, to_char(pll.secondary_quantity_accepted) secondary_quantity_accepted, to_char(pll.secondary_quantity_cancelled) secondary_quantity_cancelled, to_char(pll.secondary_quantity_received) secondary_quantity_received, to_char(pll.secondary_quantity_rejected) secondary_quantity_rejected, to_char(pll.secondary_quantity_shipped) secondary_quantity_shipped, pll.secondary_unit_of_measure, to_char(pll.shipment_closed_date) shipment_closed_date, to_char(pll.shipment_num) shipment_num, pll.shipment_type, to_char(pll.ship_to_location_id) ship_to_location_id, to_char(pll.ship_to_organization_id) ship_to_organization_id, pll.ship_via_lookup_code, to_char(pll.source_shipment_id) source_shipment_id, to_char(pll.start_date) start_date, pll.supplier_order_line_number, pll.taxable_flag, pll.tax_attribute_update_code, to_char(pll.tax_code_id) tax_code_id, pll.tax_name, pll.tax_user_override_flag, to_char(pll.terms_id) terms_id, to_char(pll.transaction_flow_header_id) transaction_flow_header_id, to_char(pll.uda_template_id) uda_template_id, to_char(pll.unencumbered_quantity) unencumbered_quantity, pll.unit_meas_lookup_code, pll.unit_of_measure_class, pll.ussgl_transaction_code, pll.value_basis, pll.vmi_flag, to_char(pll.work_approver_id) work_approver_id, null as change_status FROM po_line_locations_archive_all pll WHERE po_header_id = PO_GEN_DIFF_PKG.getBasePK1) po_lineloc_unpivot_data unpivot include nulls ( col_value for col_name in ( ACCRUE_ON_RECEIPT_FLAG, ALLOW_SUBSTITUTE_RECEIPTS_FLAG, AMOUNT, AMOUNT_ACCEPTED, AMOUNT_BILLED, AMOUNT_CANCELLED, AMOUNT_FINANCED, AMOUNT_RECEIVED, AMOUNT_RECOUPED, AMOUNT_REJECTED, AMOUNT_SHIPPED, APPROVED_DATE, APPROVED_FLAG, ATTRIBUTE1, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE_CATEGORY, BID_PAYMENT_ID, CALCULATE_TAX_FLAG, CANCELLED_BY, CANCEL_DATE, CANCEL_FLAG, CANCEL_REASON, CHANGE_PROMISED_DATE_REASON, CLM_DELIVERY_PERIOD, CLM_DELIVERY_PERIOD_UOM, CLM_PERIOD_PERF_END_DATE, CLM_PERIOD_PERF_START_DATE, CLM_POP_DURATION, CLM_POP_DURATION_UOM, CLM_PROMISE_PERIOD, CLM_PROMISE_PERIOD_UOM, CLOSED_BY, CLOSED_CODE, CLOSED_DATE, CLOSED_FLAG, CLOSED_FOR_INVOICE_DATE, CLOSED_FOR_RECEIVING_DATE, CLOSED_REASON, CONSIGNED_FLAG, COUNTRY_OF_ORIGIN_CODE, DAYS_EARLY_RECEIPT_ALLOWED, DAYS_LATE_RECEIPT_ALLOWED, DESCRIPTION, DROP_SHIP_FLAG, ENCUMBERED_DATE, ENCUMBERED_FLAG, ENCUMBER_NOW, END_DATE, ENFORCE_SHIP_TO_LOCATION_CODE, ESTIMATED_TAX_AMOUNT, FINAL_MATCH_FLAG, FIRM_DATE, FIRM_STATUS_LOOKUP_CODE, FOB_LOOKUP_CODE, FREIGHT_TERMS_LOOKUP_CODE, FROM_HEADER_ID, FROM_LINE_ID, FROM_LINE_LOCATION_ID, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE_CATEGORY, GOVERNMENT_CONTEXT, INSPECTION_REQUIRED_FLAG, INVOICE_CLOSE_TOLERANCE, LAST_ACCEPT_DATE, LEAD_TIME, LEAD_TIME_UNIT, MANUAL_PRICE_CHANGE_FLAG, MATCHING_BASIS, MATCH_OPTION, NEED_BY_DATE, NOTE_TO_RECEIVER, ORG_ID, OUTSOURCED_ASSEMBLY, PAYMENT_TYPE, PO_RELEASE_ID, PREFERRED_GRADE, PRICE_DISCOUNT, PRICE_OVERRIDE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, PROMISED_DATE, QTY_RCV_EXCEPTION_CODE, QTY_RCV_TOLERANCE, QUANTITY, QUANTITY_ACCEPTED, QUANTITY_BILLED, QUANTITY_CANCELLED, QUANTITY_FINANCED, QUANTITY_RECEIVED, QUANTITY_RECOUPED, QUANTITY_REJECTED, QUANTITY_SHIPPED, RECEIPT_DAYS_EXCEPTION_CODE, RECEIPT_REQUIRED_FLAG, RECEIVE_CLOSE_TOLERANCE, RECEIVING_ROUTING_ID, REQUEST_ID, RETAINAGE_RELEASED_AMOUNT, RETAINAGE_WITHHELD_AMOUNT, RETROACTIVE_DATE, SALES_ORDER_UPDATE_DATE, SECONDARY_QUANTITY, SECONDARY_QUANTITY_ACCEPTED, SECONDARY_QUANTITY_CANCELLED, SECONDARY_QUANTITY_RECEIVED, SECONDARY_QUANTITY_REJECTED, SECONDARY_QUANTITY_SHIPPED, SECONDARY_UNIT_OF_MEASURE, SHIPMENT_CLOSED_DATE, SHIPMENT_NUM, SHIPMENT_TYPE, SHIP_TO_LOCATION_ID, SHIP_TO_ORGANIZATION_ID, SHIP_VIA_LOOKUP_CODE, SOURCE_SHIPMENT_ID, START_DATE, SUPPLIER_ORDER_LINE_NUMBER, TAXABLE_FLAG, TAX_ATTRIBUTE_UPDATE_CODE, TAX_CODE_ID, TAX_NAME, TAX_USER_OVERRIDE_FLAG, TERMS_ID, TRANSACTION_FLOW_HEADER_ID, UDA_TEMPLATE_ID, UNENCUMBERED_QUANTITY, UNIT_MEAS_LOOKUP_CODE, UNIT_OF_MEASURE_CLASS, USSGL_TRANSACTION_CODE, VALUE_BASIS, VMI_FLAG, WORK_APPROVER_ID, CHANGE_STATUS ) )

View Text - HTML Formatted

SELECT PO_HEADER_ID PK1_VALUE
, -1 PK2_VALUE
, PO_LINE_ID PK3_VALUE
, LINE_LOCATION_ID PK4_VALUE
, NULL PK5_VALUE
, COL_NAME
, COL_VALUE
, REVISION_NUM
FROM ( SELECT PLL.PO_HEADER_ID
, -1 DRAFT_ID
, PLL.PO_LINE_ID
, PLL.LINE_LOCATION_ID
, PLL.ACCRUE_ON_RECEIPT_FLAG
, PLL.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, TO_CHAR(PLL.AMOUNT) AMOUNT
, TO_CHAR(PLL.AMOUNT_ACCEPTED) AMOUNT_ACCEPTED
, TO_CHAR(PLL.AMOUNT_BILLED) AMOUNT_BILLED
, TO_CHAR(PLL.AMOUNT_CANCELLED) AMOUNT_CANCELLED
, TO_CHAR(PLL.AMOUNT_FINANCED) AMOUNT_FINANCED
, TO_CHAR(PLL.AMOUNT_RECEIVED) AMOUNT_RECEIVED
, TO_CHAR(PLL.AMOUNT_RECOUPED) AMOUNT_RECOUPED
, TO_CHAR(PLL.AMOUNT_REJECTED) AMOUNT_REJECTED
, TO_CHAR(PLL.AMOUNT_SHIPPED) AMOUNT_SHIPPED
, TO_CHAR(PLL.APPROVED_DATE) APPROVED_DATE
, PLL.APPROVED_FLAG
, PLL.ATTRIBUTE1
, PLL.ATTRIBUTE10
, PLL.ATTRIBUTE11
, PLL.ATTRIBUTE12
, PLL.ATTRIBUTE13
, PLL.ATTRIBUTE14
, PLL.ATTRIBUTE15
, PLL.ATTRIBUTE2
, PLL.ATTRIBUTE3
, PLL.ATTRIBUTE4
, PLL.ATTRIBUTE5
, PLL.ATTRIBUTE6
, PLL.ATTRIBUTE7
, PLL.ATTRIBUTE8
, PLL.ATTRIBUTE9
, PLL.ATTRIBUTE_CATEGORY
, TO_CHAR(PLL.BID_PAYMENT_ID) BID_PAYMENT_ID
, PLL.CALCULATE_TAX_FLAG
, TO_CHAR(PLL.CANCELLED_BY) CANCELLED_BY
, TO_CHAR(PLL.CANCEL_DATE) CANCEL_DATE
, PLL.CANCEL_FLAG
, PLL.CANCEL_REASON
, PLL.CHANGE_PROMISED_DATE_REASON
, TO_CHAR(PLL.CLM_DELIVERY_PERIOD) CLM_DELIVERY_PERIOD
, PLL.CLM_DELIVERY_PERIOD_UOM
, TO_CHAR(PLL.CLM_PERIOD_PERF_END_DATE) CLM_PERIOD_PERF_END_DATE
, TO_CHAR(PLL.CLM_PERIOD_PERF_START_DATE) CLM_PERIOD_PERF_START_DATE
, TO_CHAR(PLL.CLM_POP_DURATION) CLM_POP_DURATION
, PLL.CLM_POP_DURATION_UOM
, TO_CHAR(PLL.CLM_PROMISE_PERIOD) CLM_PROMISE_PERIOD
, PLL.CLM_PROMISE_PERIOD_UOM
, TO_CHAR(PLL.CLOSED_BY) CLOSED_BY
, PLL.CLOSED_CODE
, TO_CHAR(PLL.CLOSED_DATE) CLOSED_DATE
, PLL.CLOSED_FLAG
, TO_CHAR(PLL.CLOSED_FOR_INVOICE_DATE) CLOSED_FOR_INVOICE_DATE
, TO_CHAR(PLL.CLOSED_FOR_RECEIVING_DATE) CLOSED_FOR_RECEIVING_DATE
, PLL.CLOSED_REASON
, PLL.CONSIGNED_FLAG
, PLL.COUNTRY_OF_ORIGIN_CODE
, TO_CHAR(PLL.DAYS_EARLY_RECEIPT_ALLOWED) DAYS_EARLY_RECEIPT_ALLOWED
, TO_CHAR(PLL.DAYS_LATE_RECEIPT_ALLOWED) DAYS_LATE_RECEIPT_ALLOWED
, PLL.DESCRIPTION
, PLL.DROP_SHIP_FLAG
, TO_CHAR(PLL.ENCUMBERED_DATE) ENCUMBERED_DATE
, PLL.ENCUMBERED_FLAG
, PLL.ENCUMBER_NOW
, TO_CHAR(PLL.END_DATE) END_DATE
, PLL.ENFORCE_SHIP_TO_LOCATION_CODE
, TO_CHAR(PLL.ESTIMATED_TAX_AMOUNT) ESTIMATED_TAX_AMOUNT
, PLL.FINAL_MATCH_FLAG
, TO_CHAR(PLL.FIRM_DATE) FIRM_DATE
, PLL.FIRM_STATUS_LOOKUP_CODE
, PLL.FOB_LOOKUP_CODE
, PLL.FREIGHT_TERMS_LOOKUP_CODE
, TO_CHAR(PLL.FROM_HEADER_ID) FROM_HEADER_ID
, TO_CHAR(PLL.FROM_LINE_ID) FROM_LINE_ID
, TO_CHAR(PLL.FROM_LINE_LOCATION_ID) FROM_LINE_LOCATION_ID
, PLL.GLOBAL_ATTRIBUTE1
, PLL.GLOBAL_ATTRIBUTE10
, PLL.GLOBAL_ATTRIBUTE11
, PLL.GLOBAL_ATTRIBUTE12
, PLL.GLOBAL_ATTRIBUTE13
, PLL.GLOBAL_ATTRIBUTE14
, PLL.GLOBAL_ATTRIBUTE15
, PLL.GLOBAL_ATTRIBUTE16
, PLL.GLOBAL_ATTRIBUTE17
, PLL.GLOBAL_ATTRIBUTE18
, PLL.GLOBAL_ATTRIBUTE19
, PLL.GLOBAL_ATTRIBUTE2
, PLL.GLOBAL_ATTRIBUTE20
, PLL.GLOBAL_ATTRIBUTE3
, PLL.GLOBAL_ATTRIBUTE4
, PLL.GLOBAL_ATTRIBUTE5
, PLL.GLOBAL_ATTRIBUTE6
, PLL.GLOBAL_ATTRIBUTE7
, PLL.GLOBAL_ATTRIBUTE8
, PLL.GLOBAL_ATTRIBUTE9
, PLL.GLOBAL_ATTRIBUTE_CATEGORY
, PLL.GOVERNMENT_CONTEXT
, PLL.INSPECTION_REQUIRED_FLAG
, TO_CHAR(PLL.INVOICE_CLOSE_TOLERANCE) INVOICE_CLOSE_TOLERANCE
, TO_CHAR(PLL.LAST_ACCEPT_DATE) LAST_ACCEPT_DATE
, TO_CHAR(PLL.LEAD_TIME) LEAD_TIME
, PLL.LEAD_TIME_UNIT
, PLL.MANUAL_PRICE_CHANGE_FLAG
, PLL.MATCHING_BASIS
, PLL.MATCH_OPTION
, TO_CHAR(PLL.NEED_BY_DATE) NEED_BY_DATE
, PLL.NOTE_TO_RECEIVER
, TO_CHAR(PLL.ORG_ID) ORG_ID
, TO_CHAR(PLL.OUTSOURCED_ASSEMBLY) OUTSOURCED_ASSEMBLY
, PLL.PAYMENT_TYPE
, TO_CHAR(PLL.PO_RELEASE_ID) PO_RELEASE_ID
, PLL.PREFERRED_GRADE
, TO_CHAR(PLL.PRICE_DISCOUNT) PRICE_DISCOUNT
, TO_CHAR(PLL.PRICE_OVERRIDE) PRICE_OVERRIDE
, TO_CHAR(PLL.PROGRAM_APPLICATION_ID) PROGRAM_APPLICATION_ID
, TO_CHAR(PLL.PROGRAM_ID) PROGRAM_ID
, TO_CHAR(PLL.PROGRAM_UPDATE_DATE) PROGRAM_UPDATE_DATE
, TO_CHAR(PLL.PROMISED_DATE) PROMISED_DATE
, PLL.QTY_RCV_EXCEPTION_CODE
, TO_CHAR(PLL.QTY_RCV_TOLERANCE) QTY_RCV_TOLERANCE
, TO_CHAR(PLL.QUANTITY) QUANTITY
, TO_CHAR(PLL.QUANTITY_ACCEPTED) QUANTITY_ACCEPTED
, TO_CHAR(PLL.QUANTITY_BILLED) QUANTITY_BILLED
, TO_CHAR(PLL.QUANTITY_CANCELLED) QUANTITY_CANCELLED
, TO_CHAR(PLL.QUANTITY_FINANCED) QUANTITY_FINANCED
, TO_CHAR(PLL.QUANTITY_RECEIVED) QUANTITY_RECEIVED
, TO_CHAR(PLL.QUANTITY_RECOUPED) QUANTITY_RECOUPED
, TO_CHAR(PLL.QUANTITY_REJECTED) QUANTITY_REJECTED
, TO_CHAR(PLL.QUANTITY_SHIPPED) QUANTITY_SHIPPED
, PLL.RECEIPT_DAYS_EXCEPTION_CODE
, PLL.RECEIPT_REQUIRED_FLAG
, TO_CHAR(PLL.RECEIVE_CLOSE_TOLERANCE) RECEIVE_CLOSE_TOLERANCE
, TO_CHAR(PLL.RECEIVING_ROUTING_ID) RECEIVING_ROUTING_ID
, TO_CHAR(PLL.REQUEST_ID) REQUEST_ID
, TO_CHAR(PLL.RETAINAGE_RELEASED_AMOUNT) RETAINAGE_RELEASED_AMOUNT
, TO_CHAR(PLL.RETAINAGE_WITHHELD_AMOUNT) RETAINAGE_WITHHELD_AMOUNT
, TO_CHAR(PLL.RETROACTIVE_DATE) RETROACTIVE_DATE
, TO_CHAR(PLL.REVISION_NUM) REVISION_NUM
, TO_CHAR(PLL.SALES_ORDER_UPDATE_DATE) SALES_ORDER_UPDATE_DATE
, TO_CHAR(PLL.SECONDARY_QUANTITY) SECONDARY_QUANTITY
, TO_CHAR(PLL.SECONDARY_QUANTITY_ACCEPTED) SECONDARY_QUANTITY_ACCEPTED
, TO_CHAR(PLL.SECONDARY_QUANTITY_CANCELLED) SECONDARY_QUANTITY_CANCELLED
, TO_CHAR(PLL.SECONDARY_QUANTITY_RECEIVED) SECONDARY_QUANTITY_RECEIVED
, TO_CHAR(PLL.SECONDARY_QUANTITY_REJECTED) SECONDARY_QUANTITY_REJECTED
, TO_CHAR(PLL.SECONDARY_QUANTITY_SHIPPED) SECONDARY_QUANTITY_SHIPPED
, PLL.SECONDARY_UNIT_OF_MEASURE
, TO_CHAR(PLL.SHIPMENT_CLOSED_DATE) SHIPMENT_CLOSED_DATE
, TO_CHAR(PLL.SHIPMENT_NUM) SHIPMENT_NUM
, PLL.SHIPMENT_TYPE
, TO_CHAR(PLL.SHIP_TO_LOCATION_ID) SHIP_TO_LOCATION_ID
, TO_CHAR(PLL.SHIP_TO_ORGANIZATION_ID) SHIP_TO_ORGANIZATION_ID
, PLL.SHIP_VIA_LOOKUP_CODE
, TO_CHAR(PLL.SOURCE_SHIPMENT_ID) SOURCE_SHIPMENT_ID
, TO_CHAR(PLL.START_DATE) START_DATE
, PLL.SUPPLIER_ORDER_LINE_NUMBER
, PLL.TAXABLE_FLAG
, PLL.TAX_ATTRIBUTE_UPDATE_CODE
, TO_CHAR(PLL.TAX_CODE_ID) TAX_CODE_ID
, PLL.TAX_NAME
, PLL.TAX_USER_OVERRIDE_FLAG
, TO_CHAR(PLL.TERMS_ID) TERMS_ID
, TO_CHAR(PLL.TRANSACTION_FLOW_HEADER_ID) TRANSACTION_FLOW_HEADER_ID
, TO_CHAR(PLL.UDA_TEMPLATE_ID) UDA_TEMPLATE_ID
, TO_CHAR(PLL.UNENCUMBERED_QUANTITY) UNENCUMBERED_QUANTITY
, PLL.UNIT_MEAS_LOOKUP_CODE
, PLL.UNIT_OF_MEASURE_CLASS
, PLL.USSGL_TRANSACTION_CODE
, PLL.VALUE_BASIS
, PLL.VMI_FLAG
, TO_CHAR(PLL.WORK_APPROVER_ID) WORK_APPROVER_ID
, NULL AS CHANGE_STATUS
FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
WHERE PO_HEADER_ID = PO_GEN_DIFF_PKG.GETBASEPK1) PO_LINELOC_UNPIVOT_DATA UNPIVOT INCLUDE NULLS ( COL_VALUE FOR COL_NAME IN ( ACCRUE_ON_RECEIPT_FLAG
, ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, AMOUNT
, AMOUNT_ACCEPTED
, AMOUNT_BILLED
, AMOUNT_CANCELLED
, AMOUNT_FINANCED
, AMOUNT_RECEIVED
, AMOUNT_RECOUPED
, AMOUNT_REJECTED
, AMOUNT_SHIPPED
, APPROVED_DATE
, APPROVED_FLAG
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, BID_PAYMENT_ID
, CALCULATE_TAX_FLAG
, CANCELLED_BY
, CANCEL_DATE
, CANCEL_FLAG
, CANCEL_REASON
, CHANGE_PROMISED_DATE_REASON
, CLM_DELIVERY_PERIOD
, CLM_DELIVERY_PERIOD_UOM
, CLM_PERIOD_PERF_END_DATE
, CLM_PERIOD_PERF_START_DATE
, CLM_POP_DURATION
, CLM_POP_DURATION_UOM
, CLM_PROMISE_PERIOD
, CLM_PROMISE_PERIOD_UOM
, CLOSED_BY
, CLOSED_CODE
, CLOSED_DATE
, CLOSED_FLAG
, CLOSED_FOR_INVOICE_DATE
, CLOSED_FOR_RECEIVING_DATE
, CLOSED_REASON
, CONSIGNED_FLAG
, COUNTRY_OF_ORIGIN_CODE
, DAYS_EARLY_RECEIPT_ALLOWED
, DAYS_LATE_RECEIPT_ALLOWED
, DESCRIPTION
, DROP_SHIP_FLAG
, ENCUMBERED_DATE
, ENCUMBERED_FLAG
, ENCUMBER_NOW
, END_DATE
, ENFORCE_SHIP_TO_LOCATION_CODE
, ESTIMATED_TAX_AMOUNT
, FINAL_MATCH_FLAG
, FIRM_DATE
, FIRM_STATUS_LOOKUP_CODE
, FOB_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE
, FROM_HEADER_ID
, FROM_LINE_ID
, FROM_LINE_LOCATION_ID
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE_CATEGORY
, GOVERNMENT_CONTEXT
, INSPECTION_REQUIRED_FLAG
, INVOICE_CLOSE_TOLERANCE
, LAST_ACCEPT_DATE
, LEAD_TIME
, LEAD_TIME_UNIT
, MANUAL_PRICE_CHANGE_FLAG
, MATCHING_BASIS
, MATCH_OPTION
, NEED_BY_DATE
, NOTE_TO_RECEIVER
, ORG_ID
, OUTSOURCED_ASSEMBLY
, PAYMENT_TYPE
, PO_RELEASE_ID
, PREFERRED_GRADE
, PRICE_DISCOUNT
, PRICE_OVERRIDE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROMISED_DATE
, QTY_RCV_EXCEPTION_CODE
, QTY_RCV_TOLERANCE
, QUANTITY
, QUANTITY_ACCEPTED
, QUANTITY_BILLED
, QUANTITY_CANCELLED
, QUANTITY_FINANCED
, QUANTITY_RECEIVED
, QUANTITY_RECOUPED
, QUANTITY_REJECTED
, QUANTITY_SHIPPED
, RECEIPT_DAYS_EXCEPTION_CODE
, RECEIPT_REQUIRED_FLAG
, RECEIVE_CLOSE_TOLERANCE
, RECEIVING_ROUTING_ID
, REQUEST_ID
, RETAINAGE_RELEASED_AMOUNT
, RETAINAGE_WITHHELD_AMOUNT
, RETROACTIVE_DATE
, SALES_ORDER_UPDATE_DATE
, SECONDARY_QUANTITY
, SECONDARY_QUANTITY_ACCEPTED
, SECONDARY_QUANTITY_CANCELLED
, SECONDARY_QUANTITY_RECEIVED
, SECONDARY_QUANTITY_REJECTED
, SECONDARY_QUANTITY_SHIPPED
, SECONDARY_UNIT_OF_MEASURE
, SHIPMENT_CLOSED_DATE
, SHIPMENT_NUM
, SHIPMENT_TYPE
, SHIP_TO_LOCATION_ID
, SHIP_TO_ORGANIZATION_ID
, SHIP_VIA_LOOKUP_CODE
, SOURCE_SHIPMENT_ID
, START_DATE
, SUPPLIER_ORDER_LINE_NUMBER
, TAXABLE_FLAG
, TAX_ATTRIBUTE_UPDATE_CODE
, TAX_CODE_ID
, TAX_NAME
, TAX_USER_OVERRIDE_FLAG
, TERMS_ID
, TRANSACTION_FLOW_HEADER_ID
, UDA_TEMPLATE_ID
, UNENCUMBERED_QUANTITY
, UNIT_MEAS_LOOKUP_CODE
, UNIT_OF_MEASURE_CLASS
, USSGL_TRANSACTION_CODE
, VALUE_BASIS
, VMI_FLAG
, WORK_APPROVER_ID
, CHANGE_STATUS ) )