VIEW: APPS.PO_LINE_LOCATION_CHANGES_V

Source

View Text - Preformatted

SELECT "MOD_DOC_PK1_VAL", "MOD_DOC_PK2_VAL", "MOD_DOC_PK4_VAL", "ENTITY_NAME", "MOD_DOC_PK3_VAL", "QUANTITY", "QUANTITY_RECEIVED", "QUANTITY_ACCEPTED", "QUANTITY_REJECTED", "QUANTITY_BILLED", "QUANTITY_CANCELLED", "UNIT_MEAS_LOOKUP_CODE", "PO_RELEASE_ID", "SHIP_TO_LOCATION_ID", "SHIP_VIA_LOOKUP_CODE", "NEED_BY_DATE", "PROMISED_DATE", "LAST_ACCEPT_DATE", "PRICE_OVERRIDE", "ENCUMBERED_FLAG", "ENCUMBERED_DATE", "UNENCUMBERED_QUANTITY", "FOB_LOOKUP_CODE", "FREIGHT_TERMS_LOOKUP_CODE", "TAXABLE_FLAG", "TAX_NAME", "ESTIMATED_TAX_AMOUNT", "FROM_HEADER_ID", "FROM_LINE_ID", "FROM_LINE_LOCATION_ID", "START_DATE", "END_DATE", "LEAD_TIME", "LEAD_TIME_UNIT", "PRICE_DISCOUNT", "TERMS_ID", "APPROVED_FLAG", "APPROVED_DATE", "CLOSED_CODE", "CANCEL_FLAG", "CANCELLED_BY", "CANCEL_DATE", "CANCEL_REASON", "FIRM_STATUS_LOOKUP_CODE", "FIRM_DATE", "ATTRIBUTE_CATEGORY", "ATTRIBUTE1", "ATTRIBUTE2", "ATTRIBUTE3", "ATTRIBUTE4", "ATTRIBUTE5", "ATTRIBUTE6", "ATTRIBUTE7", "ATTRIBUTE8", "ATTRIBUTE9", "ATTRIBUTE10", "UNIT_OF_MEASURE_CLASS", "ENCUMBER_NOW", "ATTRIBUTE11", "ATTRIBUTE12", "ATTRIBUTE13", "ATTRIBUTE14", "ATTRIBUTE15", "INSPECTION_REQUIRED_FLAG", "RECEIPT_REQUIRED_FLAG", "QTY_RCV_TOLERANCE", "QTY_RCV_EXCEPTION_CODE", "ENFORCE_SHIP_TO_LOCATION_CODE", "ALLOW_SUBSTITUTE_RECEIPTS_FLAG", "DAYS_EARLY_RECEIPT_ALLOWED", "DAYS_LATE_RECEIPT_ALLOWED", "RECEIPT_DAYS_EXCEPTION_CODE", "SHIP_TO_ORGANIZATION_ID", "SHIPMENT_NUM", "SOURCE_SHIPMENT_ID", "SHIPMENT_TYPE", "USSGL_TRANSACTION_CODE", "GOVERNMENT_CONTEXT", "REVISION_NUM", "LATEST_EXTERNAL_FLAG", "RECEIVING_ROUTING_ID", "REQUEST_ID", "PROGRAM_APPLICATION_ID", "PROGRAM_ID", "PROGRAM_UPDATE_DATE", "INVOICE_CLOSE_TOLERANCE", "RECEIVE_CLOSE_TOLERANCE", "ACCRUE_ON_RECEIPT_FLAG", "CLOSED_BY", "CLOSED_DATE", "CLOSED_REASON", "CLOSED_FLAG", "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_ATTRIBUTE14", "GLOBAL_ATTRIBUTE15", "GLOBAL_ATTRIBUTE16", "GLOBAL_ATTRIBUTE17", "GLOBAL_ATTRIBUTE18", "GLOBAL_ATTRIBUTE19", "GLOBAL_ATTRIBUTE20", "QUANTITY_SHIPPED", "TAX_USER_OVERRIDE_FLAG", "MATCH_OPTION", "TAX_CODE_ID", "CHANGE_PROMISED_DATE_REASON", "SECONDARY_UNIT_OF_MEASURE", "SECONDARY_QUANTITY", "PREFERRED_GRADE", "SECONDARY_QUANTITY_RECEIVED", "SECONDARY_QUANTITY_ACCEPTED", "SECONDARY_QUANTITY_REJECTED", "SECONDARY_QUANTITY_CANCELLED", "CONSIGNED_FLAG", "SUPPLIER_ORDER_LINE_NUMBER", "COUNTRY_OF_ORIGIN_CODE", "CALCULATE_TAX_FLAG", "NOTE_TO_RECEIVER", "AMOUNT", "AMOUNT_RECEIVED", "AMOUNT_BILLED", "AMOUNT_CANCELLED", "AMOUNT_ACCEPTED", "AMOUNT_REJECTED", "VMI_FLAG", "RETROACTIVE_DATE", "DROP_SHIP_FLAG", "SALES_ORDER_UPDATE_DATE", "TRANSACTION_FLOW_HEADER_ID", "FINAL_MATCH_FLAG", "MANUAL_PRICE_CHANGE_FLAG", "SHIPMENT_CLOSED_DATE", "CLOSED_FOR_RECEIVING_DATE", "CLOSED_FOR_INVOICE_DATE", "SECONDARY_QUANTITY_SHIPPED", "VALUE_BASIS", "MATCHING_BASIS", "PAYMENT_TYPE", "DESCRIPTION", "WORK_APPROVER_ID", "BID_PAYMENT_ID", "QUANTITY_FINANCED", "AMOUNT_FINANCED", "QUANTITY_RECOUPED", "AMOUNT_RECOUPED", "RETAINAGE_WITHHELD_AMOUNT", "RETAINAGE_RELEASED_AMOUNT", "OUTSOURCED_ASSEMBLY", "AMOUNT_SHIPPED", "CLM_PERIOD_PERF_END_DATE", "CLM_PERIOD_PERF_START_DATE", "LCM_FLAG", "ORIGINAL_SHIPMENT_ID", "TAX_ATTRIBUTE_UPDATE_CODE", "UDA_TEMPLATE_ID", "CLM_DELIVERY_PERIOD", "CLM_PROMISE_PERIOD", "CLM_POP_DURATION", "CLM_DELIVERY_PERIOD_UOM", "CLM_PROMISE_PERIOD_UOM", "CLM_POP_DURATION_UOM" FROM (SELECT MOD_DOC_PK1_VAL,MOD_DOC_PK2_VAL,MOD_DOC_PK4_VAL, ENTITY_NAME,MOD_DOC_PK3_VAL, column_name,mod_value from po_entity_differences where MOD_DOC_SOURCE_NAME = 'PO_LINELOCS_DRAFT_DIFF_V' AND entity_name = 'LINELOCATION') pivot(Max(mod_value) FOR column_name IN ( 'LINE_LOCATION_ID' LINE_LOCATION_ID, 'PO_LINE_ID' PO_LINE_ID, 'QUANTITY' QUANTITY, 'QUANTITY_RECEIVED' QUANTITY_RECEIVED, 'QUANTITY_ACCEPTED' QUANTITY_ACCEPTED, 'QUANTITY_REJECTED' QUANTITY_REJECTED, 'QUANTITY_BILLED' QUANTITY_BILLED , 'QUANTITY_CANCELLED' QUANTITY_CANCELLED, 'UNIT_MEAS_LOOKUP_CODE' UNIT_MEAS_LOOKUP_CODE, 'PO_RELEASE_ID' PO_RELEASE_ID, 'SHIP_TO_LOCATION_ID' SHIP_TO_LOCATION_ID, 'SHIP_VIA_LOOKUP_CODE' SHIP_VIA_LOOKUP_CODE, 'NEED_BY_DATE' NEED_BY_DATE, 'PROMISED_DATE' PROMISED_DATE, 'LAST_ACCEPT_DATE' LAST_ACCEPT_DATE, 'PRICE_OVERRIDE' PRICE_OVERRIDE, 'ENCUMBERED_FLAG' ENCUMBERED_FLAG, 'ENCUMBERED_DATE' ENCUMBERED_DATE, 'UNENCUMBERED_QUANTITY' UNENCUMBERED_QUANTITY, 'FOB_LOOKUP_CODE' FOB_LOOKUP_CODE, 'FREIGHT_TERMS_LOOKUP_CODE' FREIGHT_TERMS_LOOKUP_CODE, 'TAXABLE_FLAG' TAXABLE_FLAG, 'TAX_NAME' TAX_NAME, 'ESTIMATED_TAX_AMOUNT' ESTIMATED_TAX_AMOUNT, 'FROM_HEADER_ID' FROM_HEADER_ID, 'FROM_LINE_ID' FROM_LINE_ID, 'FROM_LINE_LOCATION_ID' FROM_LINE_LOCATION_ID, 'START_DATE' START_DATE, 'END_DATE' END_DATE, 'LEAD_TIME' LEAD_TIME, 'LEAD_TIME_UNIT' LEAD_TIME_UNIT, 'PRICE_DISCOUNT' PRICE_DISCOUNT, 'TERMS_ID' TERMS_ID, 'APPROVED_FLAG' APPROVED_FLAG, 'APPROVED_DATE' APPROVED_DATE, 'CLOSED_CODE' CLOSED_CODE, 'CANCEL_FLAG' CANCEL_FLAG, 'CANCELLED_BY' CANCELLED_BY, 'CANCEL_DATE' CANCEL_DATE, 'CANCEL_REASON' CANCEL_REASON, 'FIRM_STATUS_LOOKUP_CODE' FIRM_STATUS_LOOKUP_CODE, 'FIRM_DATE' FIRM_DATE, 'ATTRIBUTE_CATEGORY' ATTRIBUTE_CATEGORY, 'ATTRIBUTE1' ATTRIBUTE1, 'ATTRIBUTE2' ATTRIBUTE2, 'ATTRIBUTE3' ATTRIBUTE3, 'ATTRIBUTE4' ATTRIBUTE4, 'ATTRIBUTE5' ATTRIBUTE5, 'ATTRIBUTE6' ATTRIBUTE6, 'ATTRIBUTE7' ATTRIBUTE7, 'ATTRIBUTE8' ATTRIBUTE8, 'ATTRIBUTE9' ATTRIBUTE9, 'ATTRIBUTE10' ATTRIBUTE10, 'UNIT_OF_MEASURE_CLASS' UNIT_OF_MEASURE_CLASS, 'ENCUMBER_NOW' ENCUMBER_NOW, 'ATTRIBUTE11' ATTRIBUTE11, 'ATTRIBUTE12' ATTRIBUTE12, 'ATTRIBUTE13' ATTRIBUTE13, 'ATTRIBUTE14' ATTRIBUTE14, 'ATTRIBUTE15' ATTRIBUTE15, 'INSPECTION_REQUIRED_FLAG' INSPECTION_REQUIRED_FLAG, 'RECEIPT_REQUIRED_FLAG' RECEIPT_REQUIRED_FLAG, 'QTY_RCV_TOLERANCE' QTY_RCV_TOLERANCE, 'QTY_RCV_EXCEPTION_CODE' QTY_RCV_EXCEPTION_CODE, 'ENFORCE_SHIP_TO_LOCATION_CODE' ENFORCE_SHIP_TO_LOCATION_CODE, 'ALLOW_SUBSTITUTE_RECEIPTS_FLAG' ALLOW_SUBSTITUTE_RECEIPTS_FLAG, 'DAYS_EARLY_RECEIPT_ALLOWED' DAYS_EARLY_RECEIPT_ALLOWED, 'DAYS_LATE_RECEIPT_ALLOWED' DAYS_LATE_RECEIPT_ALLOWED, 'RECEIPT_DAYS_EXCEPTION_CODE' RECEIPT_DAYS_EXCEPTION_CODE, 'SHIP_TO_ORGANIZATION_ID' SHIP_TO_ORGANIZATION_ID, 'SHIPMENT_NUM' SHIPMENT_NUM, 'SOURCE_SHIPMENT_ID' SOURCE_SHIPMENT_ID, 'SHIPMENT_TYPE' SHIPMENT_TYPE , 'USSGL_TRANSACTION_CODE' USSGL_TRANSACTION_CODE, 'GOVERNMENT_CONTEXT' GOVERNMENT_CONTEXT, 'REVISION_NUM' REVISION_NUM, 'LATEST_EXTERNAL_FLAG' LATEST_EXTERNAL_FLAG, 'RECEIVING_ROUTING_ID' RECEIVING_ROUTING_ID, 'REQUEST_ID' REQUEST_ID, 'PROGRAM_APPLICATION_ID' PROGRAM_APPLICATION_ID, 'PROGRAM_ID' PROGRAM_ID, 'PROGRAM_UPDATE_DATE' PROGRAM_UPDATE_DATE, 'INVOICE_CLOSE_TOLERANCE' INVOICE_CLOSE_TOLERANCE, 'RECEIVE_CLOSE_TOLERANCE' RECEIVE_CLOSE_TOLERANCE, 'ACCRUE_ON_RECEIPT_FLAG' ACCRUE_ON_RECEIPT_FLAG, 'CLOSED_BY' CLOSED_BY, 'CLOSED_DATE' CLOSED_DATE, 'CLOSED_REASON' CLOSED_REASON, 'CLOSED_FLAG' CLOSED_FLAG, 'ORG_ID' ORG_ID, 'GLOBAL_ATTRIBUTE_CATEGORY' GLOBAL_ATTRIBUTE_CATEGORY, 'GLOBAL_ATTRIBUTE1' GLOBAL_ATTRIBUTE1, 'GLOBAL_ATTRIBUTE2' GLOBAL_ATTRIBUTE2, 'GLOBAL_ATTRIBUTE3' GLOBAL_ATTRIBUTE3, 'GLOBAL_ATTRIBUTE4' GLOBAL_ATTRIBUTE4, 'GLOBAL_ATTRIBUTE5' GLOBAL_ATTRIBUTE5, 'GLOBAL_ATTRIBUTE6' GLOBAL_ATTRIBUTE6, 'GLOBAL_ATTRIBUTE7' GLOBAL_ATTRIBUTE7, 'GLOBAL_ATTRIBUTE8' GLOBAL_ATTRIBUTE8, 'GLOBAL_ATTRIBUTE9' GLOBAL_ATTRIBUTE9, 'GLOBAL_ATTRIBUTE10' GLOBAL_ATTRIBUTE10, 'GLOBAL_ATTRIBUTE11' GLOBAL_ATTRIBUTE11, 'GLOBAL_ATTRIBUTE12' GLOBAL_ATTRIBUTE12, 'GLOBAL_ATTRIBUTE13' GLOBAL_ATTRIBUTE13, 'GLOBAL_ATTRIBUTE14' GLOBAL_ATTRIBUTE14, 'GLOBAL_ATTRIBUTE15' GLOBAL_ATTRIBUTE15, 'GLOBAL_ATTRIBUTE16' GLOBAL_ATTRIBUTE16, 'GLOBAL_ATTRIBUTE17' GLOBAL_ATTRIBUTE17, 'GLOBAL_ATTRIBUTE18' GLOBAL_ATTRIBUTE18, 'GLOBAL_ATTRIBUTE19' GLOBAL_ATTRIBUTE19, 'GLOBAL_ATTRIBUTE20' GLOBAL_ATTRIBUTE20, 'QUANTITY_SHIPPED' QUANTITY_SHIPPED, 'TAX_USER_OVERRIDE_FLAG' TAX_USER_OVERRIDE_FLAG, 'MATCH_OPTION' MATCH_OPTION, 'TAX_CODE_ID' TAX_CODE_ID, 'CHANGE_PROMISED_DATE_REASON' CHANGE_PROMISED_DATE_REASON, 'SECONDARY_UNIT_OF_MEASURE' SECONDARY_UNIT_OF_MEASURE, 'SECONDARY_QUANTITY' SECONDARY_QUANTITY, 'PREFERRED_GRADE' PREFERRED_GRADE, 'SECONDARY_QUANTITY_RECEIVED' SECONDARY_QUANTITY_RECEIVED, 'SECONDARY_QUANTITY_ACCEPTED' SECONDARY_QUANTITY_ACCEPTED, 'SECONDARY_QUANTITY_REJECTED' SECONDARY_QUANTITY_REJECTED, 'SECONDARY_QUANTITY_CANCELLED' SECONDARY_QUANTITY_CANCELLED, 'CONSIGNED_FLAG' CONSIGNED_FLAG, 'SUPPLIER_ORDER_LINE_NUMBER' SUPPLIER_ORDER_LINE_NUMBER, 'COUNTRY_OF_ORIGIN_CODE' COUNTRY_OF_ORIGIN_CODE, 'CALCULATE_TAX_FLAG' CALCULATE_TAX_FLAG, 'NOTE_TO_RECEIVER' NOTE_TO_RECEIVER, 'AMOUNT' AMOUNT, 'AMOUNT_RECEIVED' AMOUNT_RECEIVED, 'AMOUNT_BILLED' AMOUNT_BILLED, 'AMOUNT_CANCELLED' AMOUNT_CANCELLED, 'AMOUNT_ACCEPTED' AMOUNT_ACCEPTED, 'AMOUNT_REJECTED' AMOUNT_REJECTED, 'VMI_FLAG' VMI_FLAG, 'RETROACTIVE_DATE' RETROACTIVE_DATE, 'DROP_SHIP_FLAG' DROP_SHIP_FLAG, 'SALES_ORDER_UPDATE_DATE' SALES_ORDER_UPDATE_DATE, 'TRANSACTION_FLOW_HEADER_ID' TRANSACTION_FLOW_HEADER_ID, 'FINAL_MATCH_FLAG' FINAL_MATCH_FLAG, 'MANUAL_PRICE_CHANGE_FLAG' MANUAL_PRICE_CHANGE_FLAG, 'SHIPMENT_CLOSED_DATE' SHIPMENT_CLOSED_DATE, 'CLOSED_FOR_RECEIVING_DATE' CLOSED_FOR_RECEIVING_DATE, 'CLOSED_FOR_INVOICE_DATE' CLOSED_FOR_INVOICE_DATE, 'SECONDARY_QUANTITY_SHIPPED' SECONDARY_QUANTITY_SHIPPED, 'VALUE_BASIS' VALUE_BASIS, 'MATCHING_BASIS' MATCHING_BASIS, 'PAYMENT_TYPE' PAYMENT_TYPE, 'DESCRIPTION' DESCRIPTION, 'WORK_APPROVER_ID' WORK_APPROVER_ID, 'BID_PAYMENT_ID' BID_PAYMENT_ID, 'QUANTITY_FINANCED' QUANTITY_FINANCED, 'AMOUNT_FINANCED' AMOUNT_FINANCED, 'QUANTITY_RECOUPED' QUANTITY_RECOUPED, 'AMOUNT_RECOUPED' AMOUNT_RECOUPED, 'RETAINAGE_WITHHELD_AMOUNT' RETAINAGE_WITHHELD_AMOUNT, 'RETAINAGE_RELEASED_AMOUNT' RETAINAGE_RELEASED_AMOUNT, 'OUTSOURCED_ASSEMBLY' OUTSOURCED_ASSEMBLY, 'AMOUNT_SHIPPED' AMOUNT_SHIPPED, 'CLM_PERIOD_PERF_END_DATE' CLM_PERIOD_PERF_END_DATE, 'CLM_PERIOD_PERF_START_DATE' CLM_PERIOD_PERF_START_DATE, 'LCM_FLAG' LCM_FLAG, 'ORIGINAL_SHIPMENT_ID' ORIGINAL_SHIPMENT_ID, 'TAX_ATTRIBUTE_UPDATE_CODE' TAX_ATTRIBUTE_UPDATE_CODE, 'UDA_TEMPLATE_ID' UDA_TEMPLATE_ID, 'CLM_DELIVERY_PERIOD' CLM_DELIVERY_PERIOD, 'CLM_PROMISE_PERIOD' CLM_PROMISE_PERIOD, 'CLM_POP_DURATION' CLM_POP_DURATION, 'CLM_DELIVERY_PERIOD_UOM' CLM_DELIVERY_PERIOD_UOM, 'CLM_PROMISE_PERIOD_UOM' CLM_PROMISE_PERIOD_UOM, 'CLM_POP_DURATION_UOM' CLM_POP_DURATION_UOM))

View Text - HTML Formatted

SELECT "MOD_DOC_PK1_VAL"
, "MOD_DOC_PK2_VAL"
, "MOD_DOC_PK4_VAL"
, "ENTITY_NAME"
, "MOD_DOC_PK3_VAL"
, "QUANTITY"
, "QUANTITY_RECEIVED"
, "QUANTITY_ACCEPTED"
, "QUANTITY_REJECTED"
, "QUANTITY_BILLED"
, "QUANTITY_CANCELLED"
, "UNIT_MEAS_LOOKUP_CODE"
, "PO_RELEASE_ID"
, "SHIP_TO_LOCATION_ID"
, "SHIP_VIA_LOOKUP_CODE"
, "NEED_BY_DATE"
, "PROMISED_DATE"
, "LAST_ACCEPT_DATE"
, "PRICE_OVERRIDE"
, "ENCUMBERED_FLAG"
, "ENCUMBERED_DATE"
, "UNENCUMBERED_QUANTITY"
, "FOB_LOOKUP_CODE"
, "FREIGHT_TERMS_LOOKUP_CODE"
, "TAXABLE_FLAG"
, "TAX_NAME"
, "ESTIMATED_TAX_AMOUNT"
, "FROM_HEADER_ID"
, "FROM_LINE_ID"
, "FROM_LINE_LOCATION_ID"
, "START_DATE"
, "END_DATE"
, "LEAD_TIME"
, "LEAD_TIME_UNIT"
, "PRICE_DISCOUNT"
, "TERMS_ID"
, "APPROVED_FLAG"
, "APPROVED_DATE"
, "CLOSED_CODE"
, "CANCEL_FLAG"
, "CANCELLED_BY"
, "CANCEL_DATE"
, "CANCEL_REASON"
, "FIRM_STATUS_LOOKUP_CODE"
, "FIRM_DATE"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "UNIT_OF_MEASURE_CLASS"
, "ENCUMBER_NOW"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "INSPECTION_REQUIRED_FLAG"
, "RECEIPT_REQUIRED_FLAG"
, "QTY_RCV_TOLERANCE"
, "QTY_RCV_EXCEPTION_CODE"
, "ENFORCE_SHIP_TO_LOCATION_CODE"
, "ALLOW_SUBSTITUTE_RECEIPTS_FLAG"
, "DAYS_EARLY_RECEIPT_ALLOWED"
, "DAYS_LATE_RECEIPT_ALLOWED"
, "RECEIPT_DAYS_EXCEPTION_CODE"
, "SHIP_TO_ORGANIZATION_ID"
, "SHIPMENT_NUM"
, "SOURCE_SHIPMENT_ID"
, "SHIPMENT_TYPE"
, "USSGL_TRANSACTION_CODE"
, "GOVERNMENT_CONTEXT"
, "REVISION_NUM"
, "LATEST_EXTERNAL_FLAG"
, "RECEIVING_ROUTING_ID"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "INVOICE_CLOSE_TOLERANCE"
, "RECEIVE_CLOSE_TOLERANCE"
, "ACCRUE_ON_RECEIPT_FLAG"
, "CLOSED_BY"
, "CLOSED_DATE"
, "CLOSED_REASON"
, "CLOSED_FLAG"
, "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_ATTRIBUTE14"
, "GLOBAL_ATTRIBUTE15"
, "GLOBAL_ATTRIBUTE16"
, "GLOBAL_ATTRIBUTE17"
, "GLOBAL_ATTRIBUTE18"
, "GLOBAL_ATTRIBUTE19"
, "GLOBAL_ATTRIBUTE20"
, "QUANTITY_SHIPPED"
, "TAX_USER_OVERRIDE_FLAG"
, "MATCH_OPTION"
, "TAX_CODE_ID"
, "CHANGE_PROMISED_DATE_REASON"
, "SECONDARY_UNIT_OF_MEASURE"
, "SECONDARY_QUANTITY"
, "PREFERRED_GRADE"
, "SECONDARY_QUANTITY_RECEIVED"
, "SECONDARY_QUANTITY_ACCEPTED"
, "SECONDARY_QUANTITY_REJECTED"
, "SECONDARY_QUANTITY_CANCELLED"
, "CONSIGNED_FLAG"
, "SUPPLIER_ORDER_LINE_NUMBER"
, "COUNTRY_OF_ORIGIN_CODE"
, "CALCULATE_TAX_FLAG"
, "NOTE_TO_RECEIVER"
, "AMOUNT"
, "AMOUNT_RECEIVED"
, "AMOUNT_BILLED"
, "AMOUNT_CANCELLED"
, "AMOUNT_ACCEPTED"
, "AMOUNT_REJECTED"
, "VMI_FLAG"
, "RETROACTIVE_DATE"
, "DROP_SHIP_FLAG"
, "SALES_ORDER_UPDATE_DATE"
, "TRANSACTION_FLOW_HEADER_ID"
, "FINAL_MATCH_FLAG"
, "MANUAL_PRICE_CHANGE_FLAG"
, "SHIPMENT_CLOSED_DATE"
, "CLOSED_FOR_RECEIVING_DATE"
, "CLOSED_FOR_INVOICE_DATE"
, "SECONDARY_QUANTITY_SHIPPED"
, "VALUE_BASIS"
, "MATCHING_BASIS"
, "PAYMENT_TYPE"
, "DESCRIPTION"
, "WORK_APPROVER_ID"
, "BID_PAYMENT_ID"
, "QUANTITY_FINANCED"
, "AMOUNT_FINANCED"
, "QUANTITY_RECOUPED"
, "AMOUNT_RECOUPED"
, "RETAINAGE_WITHHELD_AMOUNT"
, "RETAINAGE_RELEASED_AMOUNT"
, "OUTSOURCED_ASSEMBLY"
, "AMOUNT_SHIPPED"
, "CLM_PERIOD_PERF_END_DATE"
, "CLM_PERIOD_PERF_START_DATE"
, "LCM_FLAG"
, "ORIGINAL_SHIPMENT_ID"
, "TAX_ATTRIBUTE_UPDATE_CODE"
, "UDA_TEMPLATE_ID"
, "CLM_DELIVERY_PERIOD"
, "CLM_PROMISE_PERIOD"
, "CLM_POP_DURATION"
, "CLM_DELIVERY_PERIOD_UOM"
, "CLM_PROMISE_PERIOD_UOM"
, "CLM_POP_DURATION_UOM"
FROM (SELECT MOD_DOC_PK1_VAL
, MOD_DOC_PK2_VAL
, MOD_DOC_PK4_VAL
, ENTITY_NAME
, MOD_DOC_PK3_VAL
, COLUMN_NAME
, MOD_VALUE
FROM PO_ENTITY_DIFFERENCES
WHERE MOD_DOC_SOURCE_NAME = 'PO_LINELOCS_DRAFT_DIFF_V'
AND ENTITY_NAME = 'LINELOCATION') PIVOT(MAX(MOD_VALUE) FOR COLUMN_NAME IN ( 'LINE_LOCATION_ID' LINE_LOCATION_ID
, 'PO_LINE_ID' PO_LINE_ID
, 'QUANTITY' QUANTITY
, 'QUANTITY_RECEIVED' QUANTITY_RECEIVED
, 'QUANTITY_ACCEPTED' QUANTITY_ACCEPTED
, 'QUANTITY_REJECTED' QUANTITY_REJECTED
, 'QUANTITY_BILLED' QUANTITY_BILLED
, 'QUANTITY_CANCELLED' QUANTITY_CANCELLED
, 'UNIT_MEAS_LOOKUP_CODE' UNIT_MEAS_LOOKUP_CODE
, 'PO_RELEASE_ID' PO_RELEASE_ID
, 'SHIP_TO_LOCATION_ID' SHIP_TO_LOCATION_ID
, 'SHIP_VIA_LOOKUP_CODE' SHIP_VIA_LOOKUP_CODE
, 'NEED_BY_DATE' NEED_BY_DATE
, 'PROMISED_DATE' PROMISED_DATE
, 'LAST_ACCEPT_DATE' LAST_ACCEPT_DATE
, 'PRICE_OVERRIDE' PRICE_OVERRIDE
, 'ENCUMBERED_FLAG' ENCUMBERED_FLAG
, 'ENCUMBERED_DATE' ENCUMBERED_DATE
, 'UNENCUMBERED_QUANTITY' UNENCUMBERED_QUANTITY
, 'FOB_LOOKUP_CODE' FOB_LOOKUP_CODE
, 'FREIGHT_TERMS_LOOKUP_CODE' FREIGHT_TERMS_LOOKUP_CODE
, 'TAXABLE_FLAG' TAXABLE_FLAG
, 'TAX_NAME' TAX_NAME
, 'ESTIMATED_TAX_AMOUNT' ESTIMATED_TAX_AMOUNT
, 'FROM_HEADER_ID' FROM_HEADER_ID
, 'FROM_LINE_ID' FROM_LINE_ID
, 'FROM_LINE_LOCATION_ID' FROM_LINE_LOCATION_ID
, 'START_DATE' START_DATE
, 'END_DATE' END_DATE
, 'LEAD_TIME' LEAD_TIME
, 'LEAD_TIME_UNIT' LEAD_TIME_UNIT
, 'PRICE_DISCOUNT' PRICE_DISCOUNT
, 'TERMS_ID' TERMS_ID
, 'APPROVED_FLAG' APPROVED_FLAG
, 'APPROVED_DATE' APPROVED_DATE
, 'CLOSED_CODE' CLOSED_CODE
, 'CANCEL_FLAG' CANCEL_FLAG
, 'CANCELLED_BY' CANCELLED_BY
, 'CANCEL_DATE' CANCEL_DATE
, 'CANCEL_REASON' CANCEL_REASON
, 'FIRM_STATUS_LOOKUP_CODE' FIRM_STATUS_LOOKUP_CODE
, 'FIRM_DATE' FIRM_DATE
, 'ATTRIBUTE_CATEGORY' ATTRIBUTE_CATEGORY
, 'ATTRIBUTE1' ATTRIBUTE1
, 'ATTRIBUTE2' ATTRIBUTE2
, 'ATTRIBUTE3' ATTRIBUTE3
, 'ATTRIBUTE4' ATTRIBUTE4
, 'ATTRIBUTE5' ATTRIBUTE5
, 'ATTRIBUTE6' ATTRIBUTE6
, 'ATTRIBUTE7' ATTRIBUTE7
, 'ATTRIBUTE8' ATTRIBUTE8
, 'ATTRIBUTE9' ATTRIBUTE9
, 'ATTRIBUTE10' ATTRIBUTE10
, 'UNIT_OF_MEASURE_CLASS' UNIT_OF_MEASURE_CLASS
, 'ENCUMBER_NOW' ENCUMBER_NOW
, 'ATTRIBUTE11' ATTRIBUTE11
, 'ATTRIBUTE12' ATTRIBUTE12
, 'ATTRIBUTE13' ATTRIBUTE13
, 'ATTRIBUTE14' ATTRIBUTE14
, 'ATTRIBUTE15' ATTRIBUTE15
, 'INSPECTION_REQUIRED_FLAG' INSPECTION_REQUIRED_FLAG
, 'RECEIPT_REQUIRED_FLAG' RECEIPT_REQUIRED_FLAG
, 'QTY_RCV_TOLERANCE' QTY_RCV_TOLERANCE
, 'QTY_RCV_EXCEPTION_CODE' QTY_RCV_EXCEPTION_CODE
, 'ENFORCE_SHIP_TO_LOCATION_CODE' ENFORCE_SHIP_TO_LOCATION_CODE
, 'ALLOW_SUBSTITUTE_RECEIPTS_FLAG' ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, 'DAYS_EARLY_RECEIPT_ALLOWED' DAYS_EARLY_RECEIPT_ALLOWED
, 'DAYS_LATE_RECEIPT_ALLOWED' DAYS_LATE_RECEIPT_ALLOWED
, 'RECEIPT_DAYS_EXCEPTION_CODE' RECEIPT_DAYS_EXCEPTION_CODE
, 'SHIP_TO_ORGANIZATION_ID' SHIP_TO_ORGANIZATION_ID
, 'SHIPMENT_NUM' SHIPMENT_NUM
, 'SOURCE_SHIPMENT_ID' SOURCE_SHIPMENT_ID
, 'SHIPMENT_TYPE' SHIPMENT_TYPE
, 'USSGL_TRANSACTION_CODE' USSGL_TRANSACTION_CODE
, 'GOVERNMENT_CONTEXT' GOVERNMENT_CONTEXT
, 'REVISION_NUM' REVISION_NUM
, 'LATEST_EXTERNAL_FLAG' LATEST_EXTERNAL_FLAG
, 'RECEIVING_ROUTING_ID' RECEIVING_ROUTING_ID
, 'REQUEST_ID' REQUEST_ID
, 'PROGRAM_APPLICATION_ID' PROGRAM_APPLICATION_ID
, 'PROGRAM_ID' PROGRAM_ID
, 'PROGRAM_UPDATE_DATE' PROGRAM_UPDATE_DATE
, 'INVOICE_CLOSE_TOLERANCE' INVOICE_CLOSE_TOLERANCE
, 'RECEIVE_CLOSE_TOLERANCE' RECEIVE_CLOSE_TOLERANCE
, 'ACCRUE_ON_RECEIPT_FLAG' ACCRUE_ON_RECEIPT_FLAG
, 'CLOSED_BY' CLOSED_BY
, 'CLOSED_DATE' CLOSED_DATE
, 'CLOSED_REASON' CLOSED_REASON
, 'CLOSED_FLAG' CLOSED_FLAG
, 'ORG_ID' ORG_ID
, 'GLOBAL_ATTRIBUTE_CATEGORY' GLOBAL_ATTRIBUTE_CATEGORY
, 'GLOBAL_ATTRIBUTE1' GLOBAL_ATTRIBUTE1
, 'GLOBAL_ATTRIBUTE2' GLOBAL_ATTRIBUTE2
, 'GLOBAL_ATTRIBUTE3' GLOBAL_ATTRIBUTE3
, 'GLOBAL_ATTRIBUTE4' GLOBAL_ATTRIBUTE4
, 'GLOBAL_ATTRIBUTE5' GLOBAL_ATTRIBUTE5
, 'GLOBAL_ATTRIBUTE6' GLOBAL_ATTRIBUTE6
, 'GLOBAL_ATTRIBUTE7' GLOBAL_ATTRIBUTE7
, 'GLOBAL_ATTRIBUTE8' GLOBAL_ATTRIBUTE8
, 'GLOBAL_ATTRIBUTE9' GLOBAL_ATTRIBUTE9
, 'GLOBAL_ATTRIBUTE10' GLOBAL_ATTRIBUTE10
, 'GLOBAL_ATTRIBUTE11' GLOBAL_ATTRIBUTE11
, 'GLOBAL_ATTRIBUTE12' GLOBAL_ATTRIBUTE12
, 'GLOBAL_ATTRIBUTE13' GLOBAL_ATTRIBUTE13
, 'GLOBAL_ATTRIBUTE14' GLOBAL_ATTRIBUTE14
, 'GLOBAL_ATTRIBUTE15' GLOBAL_ATTRIBUTE15
, 'GLOBAL_ATTRIBUTE16' GLOBAL_ATTRIBUTE16
, 'GLOBAL_ATTRIBUTE17' GLOBAL_ATTRIBUTE17
, 'GLOBAL_ATTRIBUTE18' GLOBAL_ATTRIBUTE18
, 'GLOBAL_ATTRIBUTE19' GLOBAL_ATTRIBUTE19
, 'GLOBAL_ATTRIBUTE20' GLOBAL_ATTRIBUTE20
, 'QUANTITY_SHIPPED' QUANTITY_SHIPPED
, 'TAX_USER_OVERRIDE_FLAG' TAX_USER_OVERRIDE_FLAG
, 'MATCH_OPTION' MATCH_OPTION
, 'TAX_CODE_ID' TAX_CODE_ID
, 'CHANGE_PROMISED_DATE_REASON' CHANGE_PROMISED_DATE_REASON
, 'SECONDARY_UNIT_OF_MEASURE' SECONDARY_UNIT_OF_MEASURE
, 'SECONDARY_QUANTITY' SECONDARY_QUANTITY
, 'PREFERRED_GRADE' PREFERRED_GRADE
, 'SECONDARY_QUANTITY_RECEIVED' SECONDARY_QUANTITY_RECEIVED
, 'SECONDARY_QUANTITY_ACCEPTED' SECONDARY_QUANTITY_ACCEPTED
, 'SECONDARY_QUANTITY_REJECTED' SECONDARY_QUANTITY_REJECTED
, 'SECONDARY_QUANTITY_CANCELLED' SECONDARY_QUANTITY_CANCELLED
, 'CONSIGNED_FLAG' CONSIGNED_FLAG
, 'SUPPLIER_ORDER_LINE_NUMBER' SUPPLIER_ORDER_LINE_NUMBER
, 'COUNTRY_OF_ORIGIN_CODE' COUNTRY_OF_ORIGIN_CODE
, 'CALCULATE_TAX_FLAG' CALCULATE_TAX_FLAG
, 'NOTE_TO_RECEIVER' NOTE_TO_RECEIVER
, 'AMOUNT' AMOUNT
, 'AMOUNT_RECEIVED' AMOUNT_RECEIVED
, 'AMOUNT_BILLED' AMOUNT_BILLED
, 'AMOUNT_CANCELLED' AMOUNT_CANCELLED
, 'AMOUNT_ACCEPTED' AMOUNT_ACCEPTED
, 'AMOUNT_REJECTED' AMOUNT_REJECTED
, 'VMI_FLAG' VMI_FLAG
, 'RETROACTIVE_DATE' RETROACTIVE_DATE
, 'DROP_SHIP_FLAG' DROP_SHIP_FLAG
, 'SALES_ORDER_UPDATE_DATE' SALES_ORDER_UPDATE_DATE
, 'TRANSACTION_FLOW_HEADER_ID' TRANSACTION_FLOW_HEADER_ID
, 'FINAL_MATCH_FLAG' FINAL_MATCH_FLAG
, 'MANUAL_PRICE_CHANGE_FLAG' MANUAL_PRICE_CHANGE_FLAG
, 'SHIPMENT_CLOSED_DATE' SHIPMENT_CLOSED_DATE
, 'CLOSED_FOR_RECEIVING_DATE' CLOSED_FOR_RECEIVING_DATE
, 'CLOSED_FOR_INVOICE_DATE' CLOSED_FOR_INVOICE_DATE
, 'SECONDARY_QUANTITY_SHIPPED' SECONDARY_QUANTITY_SHIPPED
, 'VALUE_BASIS' VALUE_BASIS
, 'MATCHING_BASIS' MATCHING_BASIS
, 'PAYMENT_TYPE' PAYMENT_TYPE
, 'DESCRIPTION' DESCRIPTION
, 'WORK_APPROVER_ID' WORK_APPROVER_ID
, 'BID_PAYMENT_ID' BID_PAYMENT_ID
, 'QUANTITY_FINANCED' QUANTITY_FINANCED
, 'AMOUNT_FINANCED' AMOUNT_FINANCED
, 'QUANTITY_RECOUPED' QUANTITY_RECOUPED
, 'AMOUNT_RECOUPED' AMOUNT_RECOUPED
, 'RETAINAGE_WITHHELD_AMOUNT' RETAINAGE_WITHHELD_AMOUNT
, 'RETAINAGE_RELEASED_AMOUNT' RETAINAGE_RELEASED_AMOUNT
, 'OUTSOURCED_ASSEMBLY' OUTSOURCED_ASSEMBLY
, 'AMOUNT_SHIPPED' AMOUNT_SHIPPED
, 'CLM_PERIOD_PERF_END_DATE' CLM_PERIOD_PERF_END_DATE
, 'CLM_PERIOD_PERF_START_DATE' CLM_PERIOD_PERF_START_DATE
, 'LCM_FLAG' LCM_FLAG
, 'ORIGINAL_SHIPMENT_ID' ORIGINAL_SHIPMENT_ID
, 'TAX_ATTRIBUTE_UPDATE_CODE' TAX_ATTRIBUTE_UPDATE_CODE
, 'UDA_TEMPLATE_ID' UDA_TEMPLATE_ID
, 'CLM_DELIVERY_PERIOD' CLM_DELIVERY_PERIOD
, 'CLM_PROMISE_PERIOD' CLM_PROMISE_PERIOD
, 'CLM_POP_DURATION' CLM_POP_DURATION
, 'CLM_DELIVERY_PERIOD_UOM' CLM_DELIVERY_PERIOD_UOM
, 'CLM_PROMISE_PERIOD_UOM' CLM_PROMISE_PERIOD_UOM
, 'CLM_POP_DURATION_UOM' CLM_POP_DURATION_UOM))