VIEW: PO.PO_LINE_LOCATIONS_ALL#

Source

View Text - Preformatted

select LINE_LOCATION_ID LINE_LOCATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, PO_HEADER_ID PO_HEADER_ID, PO_LINE_ID PO_LINE_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, 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_FLAG CLOSED_FLAG, 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, INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE, RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, SHIPMENT_NUM SHIPMENT_NUM, SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID, SHIPMENT_TYPE SHIPMENT_TYPE, CLOSED_CODE CLOSED_CODE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG, CLOSED_REASON CLOSED_REASON, CLOSED_DATE CLOSED_DATE, CLOSED_BY CLOSED_BY, ORG_ID ORG_ID, QUANTITY_SHIPPED QUANTITY_SHIPPED, 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, COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE, TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG, MATCH_OPTION MATCH_OPTION, TAX_CODE_ID TAX_CODE_ID, CALCULATE_TAX_FLAG CALCULATE_TAX_FLAG, CHANGE_PROMISED_DATE_REASON CHANGE_PROMISED_DATE_REASON, NOTE_TO_RECEIVER NOTE_TO_RECEIVER, SECONDARY_QUANTITY SECONDARY_QUANTITY, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE, 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, VMI_FLAG VMI_FLAG, CONSIGNED_FLAG CONSIGNED_FLAG, RETROACTIVE_DATE RETROACTIVE_DATE, SUPPLIER_ORDER_LINE_NUMBER SUPPLIER_ORDER_LINE_NUMBER, AMOUNT AMOUNT, AMOUNT_RECEIVED AMOUNT_RECEIVED, AMOUNT_BILLED AMOUNT_BILLED, AMOUNT_CANCELLED AMOUNT_CANCELLED, AMOUNT_REJECTED AMOUNT_REJECTED, AMOUNT_ACCEPTED AMOUNT_ACCEPTED, 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, AMOUNT_SHIPPED AMOUNT_SHIPPED, OUTSOURCED_ASSEMBLY OUTSOURCED_ASSEMBLY, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE, ORIGINAL_SHIPMENT_ID ORIGINAL_SHIPMENT_ID, LCM_FLAG LCM_FLAG, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, DRAFT_ID DRAFT_ID, CLM_PERIOD_PERF_END_DATE CLM_PERIOD_PERF_END_DATE, CLM_PERIOD_PERF_START_DATE CLM_PERIOD_PERF_START_DATE, REVISION_NUM REVISION_NUM, CLM_DELIVERY_PERIOD CLM_DELIVERY_PERIOD, CLM_DELIVERY_PERIOD_UOM CLM_DELIVERY_PERIOD_UOM, CLM_POP_DURATION CLM_POP_DURATION, CLM_POP_DURATION_UOM CLM_POP_DURATION_UOM, CLM_PROMISE_PERIOD CLM_PROMISE_PERIOD, CLM_PROMISE_PERIOD_UOM CLM_PROMISE_PERIOD_UOM from "PO"."PO_LINE_LOCATIONS_ALL"

View Text - HTML Formatted

SELECT LINE_LOCATION_ID LINE_LOCATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_ID PO_LINE_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, 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_FLAG CLOSED_FLAG
, 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
, INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE
, RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE
, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID
, SHIPMENT_NUM SHIPMENT_NUM
, SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID
, SHIPMENT_TYPE SHIPMENT_TYPE
, CLOSED_CODE CLOSED_CODE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID
, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG
, CLOSED_REASON CLOSED_REASON
, CLOSED_DATE CLOSED_DATE
, CLOSED_BY CLOSED_BY
, ORG_ID ORG_ID
, QUANTITY_SHIPPED QUANTITY_SHIPPED
, 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
, COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE
, TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG
, MATCH_OPTION MATCH_OPTION
, TAX_CODE_ID TAX_CODE_ID
, CALCULATE_TAX_FLAG CALCULATE_TAX_FLAG
, CHANGE_PROMISED_DATE_REASON CHANGE_PROMISED_DATE_REASON
, NOTE_TO_RECEIVER NOTE_TO_RECEIVER
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE
, 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
, VMI_FLAG VMI_FLAG
, CONSIGNED_FLAG CONSIGNED_FLAG
, RETROACTIVE_DATE RETROACTIVE_DATE
, SUPPLIER_ORDER_LINE_NUMBER SUPPLIER_ORDER_LINE_NUMBER
, AMOUNT AMOUNT
, AMOUNT_RECEIVED AMOUNT_RECEIVED
, AMOUNT_BILLED AMOUNT_BILLED
, AMOUNT_CANCELLED AMOUNT_CANCELLED
, AMOUNT_REJECTED AMOUNT_REJECTED
, AMOUNT_ACCEPTED AMOUNT_ACCEPTED
, 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
, AMOUNT_SHIPPED AMOUNT_SHIPPED
, OUTSOURCED_ASSEMBLY OUTSOURCED_ASSEMBLY
, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE
, ORIGINAL_SHIPMENT_ID ORIGINAL_SHIPMENT_ID
, LCM_FLAG LCM_FLAG
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, DRAFT_ID DRAFT_ID
, CLM_PERIOD_PERF_END_DATE CLM_PERIOD_PERF_END_DATE
, CLM_PERIOD_PERF_START_DATE CLM_PERIOD_PERF_START_DATE
, REVISION_NUM REVISION_NUM
, CLM_DELIVERY_PERIOD CLM_DELIVERY_PERIOD
, CLM_DELIVERY_PERIOD_UOM CLM_DELIVERY_PERIOD_UOM
, CLM_POP_DURATION CLM_POP_DURATION
, CLM_POP_DURATION_UOM CLM_POP_DURATION_UOM
, CLM_PROMISE_PERIOD CLM_PROMISE_PERIOD
, CLM_PROMISE_PERIOD_UOM CLM_PROMISE_PERIOD_UOM
FROM "PO"."PO_LINE_LOCATIONS_ALL"