PO_INTG_LINE_LOCATIONS_ARCH

Details

Schema: FUSION
Object owner: PO
Object type: VIEW

Columns

Name
LINE_LOCATION_ID WORK_ORDER_OPERATION_ID WORK_ORDER_SUB_TYPE ENTITY_CHANGE_TYPE_CODE WORK_ORDER_OPERATION_SEQ EXTERNAL_SYS_RCV_INTF_CO_SEQ FIRM_FLAG ORCHESTRATION_CODE MODE_OF_TRANSPORT SERVICE_LEVEL REQUESTED_SHIP_DATE PROMISED_SHIP_DATE FUNDS_STATUS SFO_PTR_ID SFO_AGREEMENT_NUMBER SFO_AGREEMENT_LINE_NUMBER PO_TRADING_ORGANIZATION_ID PJC_CONTEXT_CATEGORY CO_QUANTITY_CANCELLED CO_AMOUNT_CANCELLED DESTINATION_TYPE_CODE EXTERNAL_CHANGE_FLAG LAST_UPDATE_DATE FROM_CO_SEQ TO_CO_SEQ ENTITY_CO_DISPOSITION REASON_FOR_CHANGE REJECTED_BY REJECTED_BY_ROLE REJECTED_REASON PRC_BU_ID REQ_BU_ID LAST_UPDATED_BY PO_HEADER_ID PO_LINE_ID LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY PRICING_QUANTITY PRICING_UOM_CODE SHIP_TO_LOCATION_ID CARRIER_ID 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 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 ENCUMBER_NOW ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP10 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 GOVERNMENT_CONTEXT RECEIVING_ROUTING_ID REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE PROGRAM_NAME PROGRAM_APP_NAME INVOICE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE ACCRUE_ON_RECEIPT_FLAG 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 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 TAX_USER_OVERRIDE_FLAG MATCH_OPTION TAX_CODE_ID CHANGE_PROMISED_DATE_REASON SECONDARY_QUANTITY SECONDARY_UOM_CODE PREFERRED_GRADE CONSIGNED_FLAG SUPPLIER_ORDER_LINE_NUMBER COUNTRY_OF_ORIGIN_CODE CALCULATE_TAX_FLAG NOTE_TO_RECEIVER AMOUNT VMI_FLAG RETROACTIVE_DATE DROP_SHIP_FLAG SALES_ORDER_UPDATE_DATE TRANSACTION_FLOW_HEADER_ID MANUAL_PRICE_CHANGE_FLAG VALUE_BASIS MATCHING_BASIS PAYMENT_TYPE GROUP_NAME DESCRIPTION BID_PAYMENT_ID OUTSOURCED_ASSEMBLY OBJECT_VERSION_NUMBER TRX_BUSINESS_CATEGORY PRODUCT_CATEGORY PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASS_ID LINE_INTENDED_USE LINE_INTENDED_USE_ID PRODUCT_TYPE USER_DEFINED_FISC_CLASS ASSESSABLE_VALUE INPUT_TAX_CLASSIFICATION_CODE SOLDTO_BU_ID UNIT_OF_MEASURE_CLASS ORIGINAL_SHIPMENT_ID BACK_TO_BACK_FLAG CUSTOMER_PO_NUMBER CUSTOMER_PO_LINE_NUMBER CUSTOMER_PO_SCHEDULE_NUMBER CUSTOMER_ITEM CUSTOMER_ITEM_DESC SALES_ORDER_NUMBER SALES_ORDER_LINE_NUMBER SALES_ORDER_SCHEDULE_NUMBER SHIP_TO_CUST_LOCATION_ID SHIP_TO_CUST_ID SHIP_TO_CUST_CONTACT_ID CANCEL_BUDGET_DATE_OPTION REINSTATE_BUDGET_DATE_OPTION REINSTATE_BUDGET_DATE CANCEL_BUDGET_DATE FINAL_DISCHARGE_LOCATION_ID WORK_ORDER_ID WORK_ORDER_NUMBER TAX_EXCLUSIVE_PRICE RETAINAGE_RATE UOM_CODE QUANTITY

Name

LINE_LOCATION_ID

WORK_ORDER_OPERATION_ID

WORK_ORDER_SUB_TYPE

ENTITY_CHANGE_TYPE_CODE

WORK_ORDER_OPERATION_SEQ

EXTERNAL_SYS_RCV_INTF_CO_SEQ

FIRM_FLAG

ORCHESTRATION_CODE

MODE_OF_TRANSPORT

SERVICE_LEVEL

REQUESTED_SHIP_DATE

PROMISED_SHIP_DATE

FUNDS_STATUS

SFO_PTR_ID

SFO_AGREEMENT_NUMBER

SFO_AGREEMENT_LINE_NUMBER

PO_TRADING_ORGANIZATION_ID

PJC_CONTEXT_CATEGORY

CO_QUANTITY_CANCELLED

CO_AMOUNT_CANCELLED

DESTINATION_TYPE_CODE

EXTERNAL_CHANGE_FLAG

LAST_UPDATE_DATE

FROM_CO_SEQ

TO_CO_SEQ

ENTITY_CO_DISPOSITION

REASON_FOR_CHANGE

REJECTED_BY

REJECTED_BY_ROLE

REJECTED_REASON

PRC_BU_ID

REQ_BU_ID

LAST_UPDATED_BY

PO_HEADER_ID

PO_LINE_ID

LAST_UPDATE_LOGIN

CREATION_DATE

CREATED_BY

PRICING_QUANTITY

PRICING_UOM_CODE

SHIP_TO_LOCATION_ID

CARRIER_ID

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

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

ENCUMBER_NOW

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

ATTRIBUTE_TIMESTAMP6

ATTRIBUTE_TIMESTAMP7

ATTRIBUTE_TIMESTAMP8

ATTRIBUTE_TIMESTAMP9

ATTRIBUTE_TIMESTAMP10

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

GOVERNMENT_CONTEXT

RECEIVING_ROUTING_ID

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

PROGRAM_NAME

PROGRAM_APP_NAME

INVOICE_CLOSE_TOLERANCE

RECEIVE_CLOSE_TOLERANCE

ACCRUE_ON_RECEIPT_FLAG

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

GLOBAL_ATTRIBUTE_DATE1

GLOBAL_ATTRIBUTE_DATE2

GLOBAL_ATTRIBUTE_DATE3

GLOBAL_ATTRIBUTE_DATE4

GLOBAL_ATTRIBUTE_DATE5

GLOBAL_ATTRIBUTE_NUMBER1

GLOBAL_ATTRIBUTE_NUMBER2

GLOBAL_ATTRIBUTE_NUMBER3

GLOBAL_ATTRIBUTE_NUMBER4

GLOBAL_ATTRIBUTE_NUMBER5

TAX_USER_OVERRIDE_FLAG

MATCH_OPTION

TAX_CODE_ID

CHANGE_PROMISED_DATE_REASON

SECONDARY_QUANTITY

SECONDARY_UOM_CODE

PREFERRED_GRADE

CONSIGNED_FLAG

SUPPLIER_ORDER_LINE_NUMBER

COUNTRY_OF_ORIGIN_CODE

CALCULATE_TAX_FLAG

NOTE_TO_RECEIVER

AMOUNT

VMI_FLAG

RETROACTIVE_DATE

DROP_SHIP_FLAG

SALES_ORDER_UPDATE_DATE

TRANSACTION_FLOW_HEADER_ID

MANUAL_PRICE_CHANGE_FLAG

VALUE_BASIS

MATCHING_BASIS

PAYMENT_TYPE

GROUP_NAME

DESCRIPTION

BID_PAYMENT_ID

OUTSOURCED_ASSEMBLY

OBJECT_VERSION_NUMBER

TRX_BUSINESS_CATEGORY

PRODUCT_CATEGORY

PRODUCT_FISC_CLASSIFICATION

PRODUCT_FISC_CLASS_ID

LINE_INTENDED_USE

LINE_INTENDED_USE_ID

PRODUCT_TYPE

USER_DEFINED_FISC_CLASS

ASSESSABLE_VALUE

INPUT_TAX_CLASSIFICATION_CODE

SOLDTO_BU_ID

UNIT_OF_MEASURE_CLASS

ORIGINAL_SHIPMENT_ID

BACK_TO_BACK_FLAG

CUSTOMER_PO_NUMBER

CUSTOMER_PO_LINE_NUMBER

CUSTOMER_PO_SCHEDULE_NUMBER

CUSTOMER_ITEM

CUSTOMER_ITEM_DESC

SALES_ORDER_NUMBER

SALES_ORDER_LINE_NUMBER

SALES_ORDER_SCHEDULE_NUMBER

SHIP_TO_CUST_LOCATION_ID

SHIP_TO_CUST_ID

SHIP_TO_CUST_CONTACT_ID

CANCEL_BUDGET_DATE_OPTION

REINSTATE_BUDGET_DATE_OPTION

REINSTATE_BUDGET_DATE

CANCEL_BUDGET_DATE

FINAL_DISCHARGE_LOCATION_ID

WORK_ORDER_ID

WORK_ORDER_NUMBER

TAX_EXCLUSIVE_PRICE

RETAINAGE_RATE

UOM_CODE

QUANTITY

Query

SQL_Statement
SELECT PO_LINE_LOCATIONS_ARCHIVE_ALL.LINE_LOCATION_ID LINE_LOCATION_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.WORK_ORDER_OPERATION_ID WORK_ORDER_OPERATION_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.WORK_ORDER_SUB_TYPE WORK_ORDER_SUB_TYPE, PO_LINE_LOCATIONS_ARCHIVE_ALL.ENTITY_CHANGE_TYPE_CODE ENTITY_CHANGE_TYPE_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.WORK_ORDER_OPERATION_SEQ WORK_ORDER_OPERATION_SEQ, PO_LINE_LOCATIONS_ARCHIVE_ALL.EXTERNAL_SYS_RCV_INTF_CO_SEQ EXTERNAL_SYS_RCV_INTF_CO_SEQ, PO_LINE_LOCATIONS_ARCHIVE_ALL.FIRM_FLAG FIRM_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.ORCHESTRATION_CODE ORCHESTRATION_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.MODE_OF_TRANSPORT MODE_OF_TRANSPORT, PO_LINE_LOCATIONS_ARCHIVE_ALL.SERVICE_LEVEL SERVICE_LEVEL, PO_LINE_LOCATIONS_ARCHIVE_ALL.REQUESTED_SHIP_DATE REQUESTED_SHIP_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.PROMISED_SHIP_DATE PROMISED_SHIP_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.FUNDS_STATUS FUNDS_STATUS, PO_LINE_LOCATIONS_ARCHIVE_ALL.SFO_PTR_ID SFO_PTR_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.SFO_AGREEMENT_NUMBER SFO_AGREEMENT_NUMBER, PO_LINE_LOCATIONS_ARCHIVE_ALL.SFO_AGREEMENT_LINE_NUMBER SFO_AGREEMENT_LINE_NUMBER, PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_TRADING_ORGANIZATION_ID PO_TRADING_ORGANIZATION_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY, PO_LINE_LOCATIONS_ARCHIVE_ALL.CO_QUANTITY_CANCELLED CO_QUANTITY_CANCELLED, PO_LINE_LOCATIONS_ARCHIVE_ALL.CO_AMOUNT_CANCELLED CO_AMOUNT_CANCELLED, PO_LINE_LOCATIONS_ARCHIVE_ALL.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.EXTERNAL_CHANGE_FLAG EXTERNAL_CHANGE_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.LAST_UPDATE_DATE LAST_UPDATE_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_CO_SEQ FROM_CO_SEQ, PO_LINE_LOCATIONS_ARCHIVE_ALL.TO_CO_SEQ TO_CO_SEQ, PO_LINE_LOCATIONS_ARCHIVE_ALL.ENTITY_CO_DISPOSITION ENTITY_CO_DISPOSITION, PO_LINE_LOCATIONS_ARCHIVE_ALL.REASON_FOR_CHANGE REASON_FOR_CHANGE, PO_LINE_LOCATIONS_ARCHIVE_ALL.REJECTED_BY REJECTED_BY, PO_LINE_LOCATIONS_ARCHIVE_ALL.REJECTED_BY_ROLE REJECTED_BY_ROLE, PO_LINE_LOCATIONS_ARCHIVE_ALL.REJECTED_REASON REJECTED_REASON, PO_LINE_LOCATIONS_ARCHIVE_ALL.PRC_BU_ID PRC_BU_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.REQ_BU_ID REQ_BU_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.LAST_UPDATED_BY LAST_UPDATED_BY, PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_HEADER_ID PO_HEADER_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_LINE_ID PO_LINE_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PO_LINE_LOCATIONS_ARCHIVE_ALL.CREATION_DATE CREATION_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.CREATED_BY CREATED_BY, PO_LINE_LOCATIONS_ARCHIVE_ALL.QUANTITY PRICING_QUANTITY, PO_LINE_LOCATIONS_ARCHIVE_ALL.UOM_CODE PRICING_UOM_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.CARRIER_ID CARRIER_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.NEED_BY_DATE NEED_BY_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.PROMISED_DATE PROMISED_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.LAST_ACCEPT_DATE LAST_ACCEPT_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.PRICE_OVERRIDE PRICE_OVERRIDE, PO_LINE_LOCATIONS_ARCHIVE_ALL.ENCUMBERED_FLAG ENCUMBERED_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.ENCUMBERED_DATE ENCUMBERED_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY, PO_LINE_LOCATIONS_ARCHIVE_ALL.FOB_LOOKUP_CODE FOB_LOOKUP_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.TAXABLE_FLAG TAXABLE_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.TAX_NAME TAX_NAME, PO_LINE_LOCATIONS_ARCHIVE_ALL.ESTIMATED_TAX_AMOUNT ESTIMATED_TAX_AMOUNT, PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_HEADER_ID FROM_HEADER_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_LINE_ID FROM_LINE_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.START_DATE START_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.END_DATE END_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.LEAD_TIME LEAD_TIME, PO_LINE_LOCATIONS_ARCHIVE_ALL.LEAD_TIME_UNIT LEAD_TIME_UNIT, PO_LINE_LOCATIONS_ARCHIVE_ALL.PRICE_DISCOUNT PRICE_DISCOUNT, PO_LINE_LOCATIONS_ARCHIVE_ALL.TERMS_ID TERMS_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.CANCEL_FLAG CANCEL_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.CANCELLED_BY CANCELLED_BY, PO_LINE_LOCATIONS_ARCHIVE_ALL.CANCEL_DATE CANCEL_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.CANCEL_REASON CANCEL_REASON, PO_LINE_LOCATIONS_ARCHIVE_ALL.FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.FIRM_DATE FIRM_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE1 ATTRIBUTE1, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE2 ATTRIBUTE2, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE3 ATTRIBUTE3, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE4 ATTRIBUTE4, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE5 ATTRIBUTE5, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE6 ATTRIBUTE6, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE7 ATTRIBUTE7, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE8 ATTRIBUTE8, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE9 ATTRIBUTE9, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE10 ATTRIBUTE10, PO_LINE_LOCATIONS_ARCHIVE_ALL.ENCUMBER_NOW ENCUMBER_NOW, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE11 ATTRIBUTE11, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE12 ATTRIBUTE12, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE13 ATTRIBUTE13, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE14 ATTRIBUTE14, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE15 ATTRIBUTE15, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE16 ATTRIBUTE16, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE17 ATTRIBUTE17, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE18 ATTRIBUTE18, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE19 ATTRIBUTE19, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE20 ATTRIBUTE20, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE6 ATTRIBUTE_DATE6, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE7 ATTRIBUTE_DATE7, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE8 ATTRIBUTE_DATE8, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE9 ATTRIBUTE_DATE9, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE10 ATTRIBUTE_DATE10, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP6, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP7, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP8, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP9, PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_TIMESTAMP10, PO_LINE_LOCATIONS_ARCHIVE_ALL.INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE, PO_LINE_LOCATIONS_ARCHIVE_ALL.QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED, PO_LINE_LOCATIONS_ARCHIVE_ALL.DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED, PO_LINE_LOCATIONS_ARCHIVE_ALL.RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIPMENT_NUM SHIPMENT_NUM, PO_LINE_LOCATIONS_ARCHIVE_ALL.SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIPMENT_TYPE SHIPMENT_TYPE, PO_LINE_LOCATIONS_ARCHIVE_ALL.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, PO_LINE_LOCATIONS_ARCHIVE_ALL.RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.REQUEST_ID REQUEST_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, PO_LINE_LOCATIONS_ARCHIVE_ALL.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, PO_LINE_LOCATIONS_ARCHIVE_ALL.PROGRAM_NAME PROGRAM_NAME, PO_LINE_LOCATIONS_ARCHIVE_ALL.PROGRAM_APP_NAME PROGRAM_APP_NAME, PO_LINE_LOCATIONS_ARCHIVE_ALL.INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE, PO_LINE_LOCATIONS_ARCHIVE_ALL.RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE, PO_LINE_LOCATIONS_ARCHIVE_ALL.ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE1, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE2, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE3, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE4, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_DATE5, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER1, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER2, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER3, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER4, PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_NUMBER5, PO_LINE_LOCATIONS_ARCHIVE_ALL.TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.MATCH_OPTION MATCH_OPTION, PO_LINE_LOCATIONS_ARCHIVE_ALL.TAX_CODE_ID TAX_CODE_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.CHANGE_PROMISED_DATE_REASON CHANGE_PROMISED_DATE_REASON, PO_LINE_LOCATIONS_ARCHIVE_ALL.SECONDARY_QUANTITY SECONDARY_QUANTITY, PO_LINE_LOCATIONS_ARCHIVE_ALL.SECONDARY_UOM_CODE SECONDARY_UOM_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.PREFERRED_GRADE PREFERRED_GRADE, PO_LINE_LOCATIONS_ARCHIVE_ALL.CONSIGNED_FLAG CONSIGNED_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.SUPPLIER_ORDER_LINE_NUMBER SUPPLIER_ORDER_LINE_NUMBER, PO_LINE_LOCATIONS_ARCHIVE_ALL.COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.CALCULATE_TAX_FLAG CALCULATE_TAX_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.NOTE_TO_RECEIVER NOTE_TO_RECEIVER, PO_LINE_LOCATIONS_ARCHIVE_ALL.AMOUNT AMOUNT, PO_LINE_LOCATIONS_ARCHIVE_ALL.VMI_FLAG VMI_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.RETROACTIVE_DATE RETROACTIVE_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.DROP_SHIP_FLAG DROP_SHIP_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.SALES_ORDER_UPDATE_DATE SALES_ORDER_UPDATE_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.TRANSACTION_FLOW_HEADER_ID TRANSACTION_FLOW_HEADER_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.MANUAL_PRICE_CHANGE_FLAG MANUAL_PRICE_CHANGE_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.VALUE_BASIS VALUE_BASIS, PO_LINE_LOCATIONS_ARCHIVE_ALL.MATCHING_BASIS MATCHING_BASIS, PO_LINE_LOCATIONS_ARCHIVE_ALL.PAYMENT_TYPE PAYMENT_TYPE, PO_LINE_LOCATIONS_ARCHIVE_ALL.GROUP_NAME GROUP_NAME, PO_LINE_LOCATIONS_ARCHIVE_ALL.DESCRIPTION DESCRIPTION, PO_LINE_LOCATIONS_ARCHIVE_ALL.BID_PAYMENT_ID BID_PAYMENT_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.OUTSOURCED_ASSEMBLY OUTSOURCED_ASSEMBLY, PO_LINE_LOCATIONS_ARCHIVE_ALL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PO_LINE_LOCATIONS_ARCHIVE_ALL.TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY, PO_LINE_LOCATIONS_ARCHIVE_ALL.PRODUCT_CATEGORY PRODUCT_CATEGORY, PO_LINE_LOCATIONS_ARCHIVE_ALL.PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION, PO_LINE_LOCATIONS_ARCHIVE_ALL.PRODUCT_FISC_CLASS_ID PRODUCT_FISC_CLASS_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.LINE_INTENDED_USE LINE_INTENDED_USE, PO_LINE_LOCATIONS_ARCHIVE_ALL.LINE_INTENDED_USE_ID LINE_INTENDED_USE_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.PRODUCT_TYPE PRODUCT_TYPE, PO_LINE_LOCATIONS_ARCHIVE_ALL.USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS, PO_LINE_LOCATIONS_ARCHIVE_ALL.ASSESSABLE_VALUE ASSESSABLE_VALUE, PO_LINE_LOCATIONS_ARCHIVE_ALL.INPUT_TAX_CLASSIFICATION_CODE INPUT_TAX_CLASSIFICATION_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.SOLDTO_BU_ID SOLDTO_BU_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.UNIT_OF_MEASURE_CLASS UNIT_OF_MEASURE_CLASS, PO_LINE_LOCATIONS_ARCHIVE_ALL.ORIGINAL_SHIPMENT_ID ORIGINAL_SHIPMENT_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.BACK_TO_BACK_FLAG BACK_TO_BACK_FLAG, PO_LINE_LOCATIONS_ARCHIVE_ALL.CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER, PO_LINE_LOCATIONS_ARCHIVE_ALL.CUSTOMER_PO_LINE_NUMBER CUSTOMER_PO_LINE_NUMBER, PO_LINE_LOCATIONS_ARCHIVE_ALL.CUSTOMER_PO_SCHEDULE_NUMBER CUSTOMER_PO_SCHEDULE_NUMBER, PO_LINE_LOCATIONS_ARCHIVE_ALL.CUSTOMER_ITEM CUSTOMER_ITEM, PO_LINE_LOCATIONS_ARCHIVE_ALL.CUSTOMER_ITEM_DESC CUSTOMER_ITEM_DESC, PO_LINE_LOCATIONS_ARCHIVE_ALL.SALES_ORDER_NUMBER SALES_ORDER_NUMBER, PO_LINE_LOCATIONS_ARCHIVE_ALL.SALES_ORDER_LINE_NUMBER SALES_ORDER_LINE_NUMBER, PO_LINE_LOCATIONS_ARCHIVE_ALL.SALES_ORDER_SCHEDULE_NUMBER SALES_ORDER_SCHEDULE_NUMBER, PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_CUST_LOCATION_ID SHIP_TO_CUST_LOCATION_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_CUST_ID SHIP_TO_CUST_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_CUST_CONTACT_ID SHIP_TO_CUST_CONTACT_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.CANCEL_BUDGET_DATE_OPTION CANCEL_BUDGET_DATE_OPTION, PO_LINE_LOCATIONS_ARCHIVE_ALL.REINSTATE_BUDGET_DATE_OPTION REINSTATE_BUDGET_DATE_OPTION, PO_LINE_LOCATIONS_ARCHIVE_ALL.REINSTATE_BUDGET_DATE REINSTATE_BUDGET_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.CANCEL_BUDGET_DATE CANCEL_BUDGET_DATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.FINAL_DISCHARGE_LOCATION_ID FINAL_DISCHARGE_LOCATION_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.WORK_ORDER_ID WORK_ORDER_ID, PO_LINE_LOCATIONS_ARCHIVE_ALL.WORK_ORDER_NUMBER WORK_ORDER_NUMBER, PO_LINE_LOCATIONS_ARCHIVE_ALL.TAX_EXCLUSIVE_PRICE TAX_EXCLUSIVE_PRICE, PO_LINE_LOCATIONS_ARCHIVE_ALL.RETAINAGE_RATE RETAINAGE_RATE, PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIPPING_UOM_CODE UOM_CODE, PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIPPING_UOM_QUANTITY QUANTITY FROM PO_LINE_LOCATIONS_ARCHIVE_ALL

SQL_Statement

SELECT

PO_LINE_LOCATIONS_ARCHIVE_ALL.LINE_LOCATION_ID LINE_LOCATION_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.WORK_ORDER_OPERATION_ID WORK_ORDER_OPERATION_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.WORK_ORDER_SUB_TYPE WORK_ORDER_SUB_TYPE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ENTITY_CHANGE_TYPE_CODE ENTITY_CHANGE_TYPE_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.WORK_ORDER_OPERATION_SEQ WORK_ORDER_OPERATION_SEQ,

PO_LINE_LOCATIONS_ARCHIVE_ALL.EXTERNAL_SYS_RCV_INTF_CO_SEQ EXTERNAL_SYS_RCV_INTF_CO_SEQ,

PO_LINE_LOCATIONS_ARCHIVE_ALL.FIRM_FLAG FIRM_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ORCHESTRATION_CODE ORCHESTRATION_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.MODE_OF_TRANSPORT MODE_OF_TRANSPORT,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SERVICE_LEVEL SERVICE_LEVEL,

PO_LINE_LOCATIONS_ARCHIVE_ALL.REQUESTED_SHIP_DATE REQUESTED_SHIP_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PROMISED_SHIP_DATE PROMISED_SHIP_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.FUNDS_STATUS FUNDS_STATUS,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SFO_PTR_ID SFO_PTR_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SFO_AGREEMENT_NUMBER SFO_AGREEMENT_NUMBER,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SFO_AGREEMENT_LINE_NUMBER SFO_AGREEMENT_LINE_NUMBER,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_TRADING_ORGANIZATION_ID PO_TRADING_ORGANIZATION_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CO_QUANTITY_CANCELLED CO_QUANTITY_CANCELLED,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CO_AMOUNT_CANCELLED CO_AMOUNT_CANCELLED,

PO_LINE_LOCATIONS_ARCHIVE_ALL.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.EXTERNAL_CHANGE_FLAG EXTERNAL_CHANGE_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_CO_SEQ FROM_CO_SEQ,

PO_LINE_LOCATIONS_ARCHIVE_ALL.TO_CO_SEQ TO_CO_SEQ,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ENTITY_CO_DISPOSITION ENTITY_CO_DISPOSITION,

PO_LINE_LOCATIONS_ARCHIVE_ALL.REASON_FOR_CHANGE REASON_FOR_CHANGE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.REJECTED_BY REJECTED_BY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.REJECTED_BY_ROLE REJECTED_BY_ROLE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.REJECTED_REASON REJECTED_REASON,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PRC_BU_ID PRC_BU_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.REQ_BU_ID REQ_BU_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.LAST_UPDATED_BY LAST_UPDATED_BY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_HEADER_ID PO_HEADER_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_LINE_ID PO_LINE_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CREATION_DATE CREATION_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CREATED_BY CREATED_BY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.QUANTITY PRICING_QUANTITY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.UOM_CODE PRICING_UOM_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CARRIER_ID CARRIER_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.NEED_BY_DATE NEED_BY_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PROMISED_DATE PROMISED_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.LAST_ACCEPT_DATE LAST_ACCEPT_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PRICE_OVERRIDE PRICE_OVERRIDE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ENCUMBERED_FLAG ENCUMBERED_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ENCUMBERED_DATE ENCUMBERED_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.FOB_LOOKUP_CODE FOB_LOOKUP_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.TAXABLE_FLAG TAXABLE_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.TAX_NAME TAX_NAME,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ESTIMATED_TAX_AMOUNT ESTIMATED_TAX_AMOUNT,

PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_HEADER_ID FROM_HEADER_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_LINE_ID FROM_LINE_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.START_DATE START_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.END_DATE END_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.LEAD_TIME LEAD_TIME,

PO_LINE_LOCATIONS_ARCHIVE_ALL.LEAD_TIME_UNIT LEAD_TIME_UNIT,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PRICE_DISCOUNT PRICE_DISCOUNT,

PO_LINE_LOCATIONS_ARCHIVE_ALL.TERMS_ID TERMS_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CANCEL_FLAG CANCEL_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CANCELLED_BY CANCELLED_BY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CANCEL_DATE CANCEL_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CANCEL_REASON CANCEL_REASON,

PO_LINE_LOCATIONS_ARCHIVE_ALL.FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.FIRM_DATE FIRM_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE1 ATTRIBUTE1,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE2 ATTRIBUTE2,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE3 ATTRIBUTE3,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE4 ATTRIBUTE4,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE5 ATTRIBUTE5,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE6 ATTRIBUTE6,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE7 ATTRIBUTE7,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE8 ATTRIBUTE8,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE9 ATTRIBUTE9,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE10 ATTRIBUTE10,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ENCUMBER_NOW ENCUMBER_NOW,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE11 ATTRIBUTE11,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE12 ATTRIBUTE12,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE13 ATTRIBUTE13,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE14 ATTRIBUTE14,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE15 ATTRIBUTE15,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE16 ATTRIBUTE16,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE17 ATTRIBUTE17,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE18 ATTRIBUTE18,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE19 ATTRIBUTE19,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE20 ATTRIBUTE20,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE6 ATTRIBUTE_DATE6,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE7 ATTRIBUTE_DATE7,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE8 ATTRIBUTE_DATE8,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE9 ATTRIBUTE_DATE9,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_DATE10 ATTRIBUTE_DATE10,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP6,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP7,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP8,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP9,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_TIMESTAMP10,

PO_LINE_LOCATIONS_ARCHIVE_ALL.INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED,

PO_LINE_LOCATIONS_ARCHIVE_ALL.DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED,

PO_LINE_LOCATIONS_ARCHIVE_ALL.RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIPMENT_NUM SHIPMENT_NUM,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIPMENT_TYPE SHIPMENT_TYPE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT,

PO_LINE_LOCATIONS_ARCHIVE_ALL.RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.REQUEST_ID REQUEST_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

PO_LINE_LOCATIONS_ARCHIVE_ALL.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PROGRAM_NAME PROGRAM_NAME,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PROGRAM_APP_NAME PROGRAM_APP_NAME,

PO_LINE_LOCATIONS_ARCHIVE_ALL.INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE1,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE2,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE3,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE4,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_DATE5,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER1,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER2,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER3,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER4,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_NUMBER5,

PO_LINE_LOCATIONS_ARCHIVE_ALL.TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.MATCH_OPTION MATCH_OPTION,

PO_LINE_LOCATIONS_ARCHIVE_ALL.TAX_CODE_ID TAX_CODE_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CHANGE_PROMISED_DATE_REASON CHANGE_PROMISED_DATE_REASON,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SECONDARY_QUANTITY SECONDARY_QUANTITY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SECONDARY_UOM_CODE SECONDARY_UOM_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PREFERRED_GRADE PREFERRED_GRADE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CONSIGNED_FLAG CONSIGNED_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SUPPLIER_ORDER_LINE_NUMBER SUPPLIER_ORDER_LINE_NUMBER,

PO_LINE_LOCATIONS_ARCHIVE_ALL.COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CALCULATE_TAX_FLAG CALCULATE_TAX_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.NOTE_TO_RECEIVER NOTE_TO_RECEIVER,

PO_LINE_LOCATIONS_ARCHIVE_ALL.AMOUNT AMOUNT,

PO_LINE_LOCATIONS_ARCHIVE_ALL.VMI_FLAG VMI_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.RETROACTIVE_DATE RETROACTIVE_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.DROP_SHIP_FLAG DROP_SHIP_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SALES_ORDER_UPDATE_DATE SALES_ORDER_UPDATE_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.TRANSACTION_FLOW_HEADER_ID TRANSACTION_FLOW_HEADER_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.MANUAL_PRICE_CHANGE_FLAG MANUAL_PRICE_CHANGE_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.VALUE_BASIS VALUE_BASIS,

PO_LINE_LOCATIONS_ARCHIVE_ALL.MATCHING_BASIS MATCHING_BASIS,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PAYMENT_TYPE PAYMENT_TYPE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.GROUP_NAME GROUP_NAME,

PO_LINE_LOCATIONS_ARCHIVE_ALL.DESCRIPTION DESCRIPTION,

PO_LINE_LOCATIONS_ARCHIVE_ALL.BID_PAYMENT_ID BID_PAYMENT_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.OUTSOURCED_ASSEMBLY OUTSOURCED_ASSEMBLY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PO_LINE_LOCATIONS_ARCHIVE_ALL.TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PRODUCT_CATEGORY PRODUCT_CATEGORY,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PRODUCT_FISC_CLASS_ID PRODUCT_FISC_CLASS_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.LINE_INTENDED_USE LINE_INTENDED_USE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.LINE_INTENDED_USE_ID LINE_INTENDED_USE_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.PRODUCT_TYPE PRODUCT_TYPE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ASSESSABLE_VALUE ASSESSABLE_VALUE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.INPUT_TAX_CLASSIFICATION_CODE INPUT_TAX_CLASSIFICATION_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SOLDTO_BU_ID SOLDTO_BU_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.UNIT_OF_MEASURE_CLASS UNIT_OF_MEASURE_CLASS,

PO_LINE_LOCATIONS_ARCHIVE_ALL.ORIGINAL_SHIPMENT_ID ORIGINAL_SHIPMENT_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.BACK_TO_BACK_FLAG BACK_TO_BACK_FLAG,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CUSTOMER_PO_LINE_NUMBER CUSTOMER_PO_LINE_NUMBER,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CUSTOMER_PO_SCHEDULE_NUMBER CUSTOMER_PO_SCHEDULE_NUMBER,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CUSTOMER_ITEM CUSTOMER_ITEM,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CUSTOMER_ITEM_DESC CUSTOMER_ITEM_DESC,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SALES_ORDER_NUMBER SALES_ORDER_NUMBER,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SALES_ORDER_LINE_NUMBER SALES_ORDER_LINE_NUMBER,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SALES_ORDER_SCHEDULE_NUMBER SALES_ORDER_SCHEDULE_NUMBER,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_CUST_LOCATION_ID SHIP_TO_CUST_LOCATION_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_CUST_ID SHIP_TO_CUST_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIP_TO_CUST_CONTACT_ID SHIP_TO_CUST_CONTACT_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CANCEL_BUDGET_DATE_OPTION CANCEL_BUDGET_DATE_OPTION,

PO_LINE_LOCATIONS_ARCHIVE_ALL.REINSTATE_BUDGET_DATE_OPTION REINSTATE_BUDGET_DATE_OPTION,

PO_LINE_LOCATIONS_ARCHIVE_ALL.REINSTATE_BUDGET_DATE REINSTATE_BUDGET_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.CANCEL_BUDGET_DATE CANCEL_BUDGET_DATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.FINAL_DISCHARGE_LOCATION_ID FINAL_DISCHARGE_LOCATION_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.WORK_ORDER_ID WORK_ORDER_ID,

PO_LINE_LOCATIONS_ARCHIVE_ALL.WORK_ORDER_NUMBER WORK_ORDER_NUMBER,

PO_LINE_LOCATIONS_ARCHIVE_ALL.TAX_EXCLUSIVE_PRICE TAX_EXCLUSIVE_PRICE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.RETAINAGE_RATE RETAINAGE_RATE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIPPING_UOM_CODE UOM_CODE,

PO_LINE_LOCATIONS_ARCHIVE_ALL.SHIPPING_UOM_QUANTITY QUANTITY

FROM

PO_LINE_LOCATIONS_ARCHIVE_ALL