VIEW: APPS.PO_LINE_LOCS_DRAFT_DIFF_V

Source

View Text - Preformatted

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