PO_INTG_LINE_LOCATIONS

Details

Schema: FUSION
Object owner: PO
Object type: VIEW

Columns

Name
LINE_LOCATION_ID WORK_ORDER_SUB_TYPE WORK_ORDER_OPERATION_SEQ WORK_ORDER_OPERATION_ID 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 DESTINATION_TYPE_CODE AUTO_CLOSURE_MODE SCHEDULE_STATUS UNIT_OF_MEASURE_CLASS TRX_BUSINESS_CATEGORY PRODUCT_CATEGORY PRODUCT_FISC_CLASSIFICATION LINE_INTENDED_USE PRC_BU_ID REQ_BU_ID PRODUCT_TYPE USER_DEFINED_FISC_CLASS ASSESSABLE_VALUE INPUT_TAX_CLASSIFICATION_CODE LAST_UPDATE_DATE LAST_UPDATED_BY PO_HEADER_ID PO_LINE_ID LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY PRICING_QUANTITY PRICING_QUANTITY_RECEIVED PRICING_QUANTITY_ACCEPTED PRICING_QUANTITY_REJECTED QUANTITY_BILLED PRICING_QUANTITY_CANCELLED 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 FIRMED_BY FIRM_REASON 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 INVOICE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE SHIP_TO_ORGANIZATION_ID SHIPMENT_NUM SOURCE_SHIPMENT_ID SHIPMENT_TYPE REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE PROGRAM_NAME PROGRAM_APP_NAME GOVERNMENT_CONTEXT RECEIVING_ROUTING_ID ACCRUE_ON_RECEIPT_FLAG CLOSED_REASON CLOSED_DATE CLOSED_BY SOLDTO_BU_ID PRICING_QUANTITY_SHIPPED 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 COUNTRY_OF_ORIGIN_CODE TAX_USER_OVERRIDE_FLAG MATCH_OPTION TAX_CODE_ID CALCULATE_TAX_FLAG CHANGE_PROMISED_DATE_REASON NOTE_TO_RECEIVER SECONDARY_QUANTITY PREFERRED_GRADE SECONDARY_UOM_CODE SECONDARY_QUANTITY_RECEIVED SECONDARY_QUANTITY_ACCEPTED SECONDARY_QUANTITY_REJECTED SECONDARY_QUANTITY_CANCELLED VMI_FLAG CONSIGNED_FLAG RETROACTIVE_DATE SUPPLIER_ORDER_LINE_NUMBER AMOUNT AMOUNT_RECEIVED AMOUNT_BILLED AMOUNT_CANCELLED AMOUNT_REJECTED AMOUNT_ACCEPTED DROP_SHIP_FLAG SALES_ORDER_UPDATE_DATE TRANSACTION_FLOW_HEADER_ID SECONDARY_QUANTITY_SHIPPED FINAL_MATCH_FLAG MANUAL_PRICE_CHANGE_FLAG SHIPMENT_CLOSED_DATE CLOSED_FOR_RECEIVING_DATE CLOSED_FOR_INVOICE_DATE VALUE_BASIS MATCHING_BASIS PAYMENT_TYPE GROUP_NAME DESCRIPTION WORK_APPROVER_ID BID_PAYMENT_ID QUANTITY_FINANCED AMOUNT_FINANCED QUANTITY_RECOUPED AMOUNT_RECOUPED RETAINAGE_WITHHELD_AMOUNT RETAINAGE_RELEASED_AMOUNT AMOUNT_SHIPPED OUTSOURCED_ASSEMBLY TAX_ATTRIBUTE_UPDATE_CODE ORIGINAL_SHIPMENT_ID OBJECT_VERSION_NUMBER PJC_CONTEXT_CATEGORY ORIG_SCHEDULE_STATUS PRODUCT_FISC_CLASS_ID LINE_INTENDED_USE_ID EXTERNAL_SYS_RCV_INTF_STATUS 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 CANCEL_BUDGET_DATE REINSTATE_BUDGET_DATE FINAL_DISCHARGE_LOCATION_ID REOPEN_FINAL_CLOSE_DATE WORK_ORDER_ID WORK_ORDER_NUMBER ANTICIPATED_ARRIVAL_DATE DELIVERY_DATE_CONFIRMATION_REQ TAX_EXCLUSIVE_PRICE EXTERNAL_SYS_RCV_GROUP_ID RETAINAGE_RATE UOM_CODE QUANTITY_RECEIVED QUANTITY_ACCEPTED QUANTITY_REJECTED QUANTITY_SHIPPED QUANTITY_CANCELLED QUANTITY

Name

LINE_LOCATION_ID

WORK_ORDER_SUB_TYPE

WORK_ORDER_OPERATION_SEQ

WORK_ORDER_OPERATION_ID

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

DESTINATION_TYPE_CODE

AUTO_CLOSURE_MODE

SCHEDULE_STATUS

UNIT_OF_MEASURE_CLASS

TRX_BUSINESS_CATEGORY

PRODUCT_CATEGORY

PRODUCT_FISC_CLASSIFICATION

LINE_INTENDED_USE

PRC_BU_ID

REQ_BU_ID

PRODUCT_TYPE

USER_DEFINED_FISC_CLASS

ASSESSABLE_VALUE

INPUT_TAX_CLASSIFICATION_CODE

LAST_UPDATE_DATE

LAST_UPDATED_BY

PO_HEADER_ID

PO_LINE_ID

LAST_UPDATE_LOGIN

CREATION_DATE

CREATED_BY

PRICING_QUANTITY

PRICING_QUANTITY_RECEIVED

PRICING_QUANTITY_ACCEPTED

PRICING_QUANTITY_REJECTED

QUANTITY_BILLED

PRICING_QUANTITY_CANCELLED

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

FIRMED_BY

FIRM_REASON

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

INVOICE_CLOSE_TOLERANCE

RECEIVE_CLOSE_TOLERANCE

SHIP_TO_ORGANIZATION_ID

SHIPMENT_NUM

SOURCE_SHIPMENT_ID

SHIPMENT_TYPE

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

PROGRAM_NAME

PROGRAM_APP_NAME

GOVERNMENT_CONTEXT

RECEIVING_ROUTING_ID

ACCRUE_ON_RECEIPT_FLAG

CLOSED_REASON

CLOSED_DATE

CLOSED_BY

SOLDTO_BU_ID

PRICING_QUANTITY_SHIPPED

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

COUNTRY_OF_ORIGIN_CODE

TAX_USER_OVERRIDE_FLAG

MATCH_OPTION

TAX_CODE_ID

CALCULATE_TAX_FLAG

CHANGE_PROMISED_DATE_REASON

NOTE_TO_RECEIVER

SECONDARY_QUANTITY

PREFERRED_GRADE

SECONDARY_UOM_CODE

SECONDARY_QUANTITY_RECEIVED

SECONDARY_QUANTITY_ACCEPTED

SECONDARY_QUANTITY_REJECTED

SECONDARY_QUANTITY_CANCELLED

VMI_FLAG

CONSIGNED_FLAG

RETROACTIVE_DATE

SUPPLIER_ORDER_LINE_NUMBER

AMOUNT

AMOUNT_RECEIVED

AMOUNT_BILLED

AMOUNT_CANCELLED

AMOUNT_REJECTED

AMOUNT_ACCEPTED

DROP_SHIP_FLAG

SALES_ORDER_UPDATE_DATE

TRANSACTION_FLOW_HEADER_ID

SECONDARY_QUANTITY_SHIPPED

FINAL_MATCH_FLAG

MANUAL_PRICE_CHANGE_FLAG

SHIPMENT_CLOSED_DATE

CLOSED_FOR_RECEIVING_DATE

CLOSED_FOR_INVOICE_DATE

VALUE_BASIS

MATCHING_BASIS

PAYMENT_TYPE

GROUP_NAME

DESCRIPTION

WORK_APPROVER_ID

BID_PAYMENT_ID

QUANTITY_FINANCED

AMOUNT_FINANCED

QUANTITY_RECOUPED

AMOUNT_RECOUPED

RETAINAGE_WITHHELD_AMOUNT

RETAINAGE_RELEASED_AMOUNT

AMOUNT_SHIPPED

OUTSOURCED_ASSEMBLY

TAX_ATTRIBUTE_UPDATE_CODE

ORIGINAL_SHIPMENT_ID

OBJECT_VERSION_NUMBER

PJC_CONTEXT_CATEGORY

ORIG_SCHEDULE_STATUS

PRODUCT_FISC_CLASS_ID

LINE_INTENDED_USE_ID

EXTERNAL_SYS_RCV_INTF_STATUS

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

CANCEL_BUDGET_DATE

REINSTATE_BUDGET_DATE

FINAL_DISCHARGE_LOCATION_ID

REOPEN_FINAL_CLOSE_DATE

WORK_ORDER_ID

WORK_ORDER_NUMBER

ANTICIPATED_ARRIVAL_DATE

DELIVERY_DATE_CONFIRMATION_REQ

TAX_EXCLUSIVE_PRICE

EXTERNAL_SYS_RCV_GROUP_ID

RETAINAGE_RATE

UOM_CODE

QUANTITY_RECEIVED

QUANTITY_ACCEPTED

QUANTITY_REJECTED

QUANTITY_SHIPPED

QUANTITY_CANCELLED

QUANTITY

Query

SQL_Statement
SELECT PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID LINE_LOCATION_ID, PO_LINE_LOCATIONS_ALL.WORK_ORDER_SUB_TYPE WORK_ORDER_SUB_TYPE, PO_LINE_LOCATIONS_ALL.WORK_ORDER_OPERATION_SEQ WORK_ORDER_OPERATION_SEQ, PO_LINE_LOCATIONS_ALL.WORK_ORDER_OPERATION_ID WORK_ORDER_OPERATION_ID, PO_LINE_LOCATIONS_ALL.EXTERNAL_SYS_RCV_INTF_CO_SEQ EXTERNAL_SYS_RCV_INTF_CO_SEQ, PO_LINE_LOCATIONS_ALL.FIRM_FLAG FIRM_FLAG, PO_LINE_LOCATIONS_ALL.ORCHESTRATION_CODE ORCHESTRATION_CODE, PO_LINE_LOCATIONS_ALL.MODE_OF_TRANSPORT MODE_OF_TRANSPORT, PO_LINE_LOCATIONS_ALL.SERVICE_LEVEL SERVICE_LEVEL, PO_LINE_LOCATIONS_ALL.REQUESTED_SHIP_DATE REQUESTED_SHIP_DATE, PO_LINE_LOCATIONS_ALL.PROMISED_SHIP_DATE PROMISED_SHIP_DATE, PO_LINE_LOCATIONS_ALL.FUNDS_STATUS FUNDS_STATUS, PO_LINE_LOCATIONS_ALL.SFO_PTR_ID SFO_PTR_ID, PO_LINE_LOCATIONS_ALL.SFO_AGREEMENT_NUMBER SFO_AGREEMENT_NUMBER, PO_LINE_LOCATIONS_ALL.SFO_AGREEMENT_LINE_NUMBER SFO_AGREEMENT_LINE_NUMBER, PO_LINE_LOCATIONS_ALL.PO_TRADING_ORGANIZATION_ID PO_TRADING_ORGANIZATION_ID, PO_LINE_LOCATIONS_ALL.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, PO_LINE_LOCATIONS_ALL.AUTO_CLOSURE_MODE AUTO_CLOSURE_MODE, PO_LINE_LOCATIONS_ALL.SCHEDULE_STATUS SCHEDULE_STATUS, PO_LINE_LOCATIONS_ALL.UNIT_OF_MEASURE_CLASS UNIT_OF_MEASURE_CLASS, PO_LINE_LOCATIONS_ALL.TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY, PO_LINE_LOCATIONS_ALL.PRODUCT_CATEGORY PRODUCT_CATEGORY, PO_LINE_LOCATIONS_ALL.PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION, PO_LINE_LOCATIONS_ALL.LINE_INTENDED_USE LINE_INTENDED_USE, PO_LINE_LOCATIONS_ALL.PRC_BU_ID PRC_BU_ID, PO_LINE_LOCATIONS_ALL.REQ_BU_ID REQ_BU_ID, PO_LINE_LOCATIONS_ALL.PRODUCT_TYPE PRODUCT_TYPE, PO_LINE_LOCATIONS_ALL.USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS, PO_LINE_LOCATIONS_ALL.ASSESSABLE_VALUE ASSESSABLE_VALUE, PO_LINE_LOCATIONS_ALL.INPUT_TAX_CLASSIFICATION_CODE INPUT_TAX_CLASSIFICATION_CODE, PO_LINE_LOCATIONS_ALL.LAST_UPDATE_DATE LAST_UPDATE_DATE, PO_LINE_LOCATIONS_ALL.LAST_UPDATED_BY LAST_UPDATED_BY, PO_LINE_LOCATIONS_ALL.PO_HEADER_ID PO_HEADER_ID, PO_LINE_LOCATIONS_ALL.PO_LINE_ID PO_LINE_ID, PO_LINE_LOCATIONS_ALL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PO_LINE_LOCATIONS_ALL.CREATION_DATE CREATION_DATE, PO_LINE_LOCATIONS_ALL.CREATED_BY CREATED_BY, PO_LINE_LOCATIONS_ALL.QUANTITY PRICING_QUANTITY, PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED PRICING_QUANTITY_RECEIVED, PO_LINE_LOCATIONS_ALL.QUANTITY_ACCEPTED PRICING_QUANTITY_ACCEPTED, PO_LINE_LOCATIONS_ALL.QUANTITY_REJECTED PRICING_QUANTITY_REJECTED, PO_LINE_LOCATIONS_ALL.QUANTITY_BILLED QUANTITY_BILLED, PO_LINE_LOCATIONS_ALL.QUANTITY_CANCELLED PRICING_QUANTITY_CANCELLED, PO_LINE_LOCATIONS_ALL.UOM_CODE PRICING_UOM_CODE, PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, PO_LINE_LOCATIONS_ALL.CARRIER_ID CARRIER_ID, PO_LINE_LOCATIONS_ALL.NEED_BY_DATE NEED_BY_DATE, PO_LINE_LOCATIONS_ALL.PROMISED_DATE PROMISED_DATE, PO_LINE_LOCATIONS_ALL.LAST_ACCEPT_DATE LAST_ACCEPT_DATE, PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE PRICE_OVERRIDE, PO_LINE_LOCATIONS_ALL.ENCUMBERED_FLAG ENCUMBERED_FLAG, PO_LINE_LOCATIONS_ALL.ENCUMBERED_DATE ENCUMBERED_DATE, PO_LINE_LOCATIONS_ALL.UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY, PO_LINE_LOCATIONS_ALL.FOB_LOOKUP_CODE FOB_LOOKUP_CODE, PO_LINE_LOCATIONS_ALL.FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE, PO_LINE_LOCATIONS_ALL.TAXABLE_FLAG TAXABLE_FLAG, PO_LINE_LOCATIONS_ALL.TAX_NAME TAX_NAME, PO_LINE_LOCATIONS_ALL.ESTIMATED_TAX_AMOUNT ESTIMATED_TAX_AMOUNT, PO_LINE_LOCATIONS_ALL.FROM_HEADER_ID FROM_HEADER_ID, PO_LINE_LOCATIONS_ALL.FROM_LINE_ID FROM_LINE_ID, PO_LINE_LOCATIONS_ALL.FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID, PO_LINE_LOCATIONS_ALL.START_DATE START_DATE, PO_LINE_LOCATIONS_ALL.END_DATE END_DATE, PO_LINE_LOCATIONS_ALL.LEAD_TIME LEAD_TIME, PO_LINE_LOCATIONS_ALL.LEAD_TIME_UNIT LEAD_TIME_UNIT, PO_LINE_LOCATIONS_ALL.PRICE_DISCOUNT PRICE_DISCOUNT, PO_LINE_LOCATIONS_ALL.TERMS_ID TERMS_ID, PO_LINE_LOCATIONS_ALL.CANCEL_FLAG CANCEL_FLAG, PO_LINE_LOCATIONS_ALL.CANCELLED_BY CANCELLED_BY, PO_LINE_LOCATIONS_ALL.CANCEL_DATE CANCEL_DATE, PO_LINE_LOCATIONS_ALL.CANCEL_REASON CANCEL_REASON, PO_LINE_LOCATIONS_ALL.FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE, PO_LINE_LOCATIONS_ALL.FIRM_DATE FIRM_DATE, PO_LINE_LOCATIONS_ALL.FIRMED_BY FIRMED_BY, PO_LINE_LOCATIONS_ALL.FIRM_REASON FIRM_REASON, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, PO_LINE_LOCATIONS_ALL.ATTRIBUTE1 ATTRIBUTE1, PO_LINE_LOCATIONS_ALL.ATTRIBUTE2 ATTRIBUTE2, PO_LINE_LOCATIONS_ALL.ATTRIBUTE3 ATTRIBUTE3, PO_LINE_LOCATIONS_ALL.ATTRIBUTE4 ATTRIBUTE4, PO_LINE_LOCATIONS_ALL.ATTRIBUTE5 ATTRIBUTE5, PO_LINE_LOCATIONS_ALL.ATTRIBUTE6 ATTRIBUTE6, PO_LINE_LOCATIONS_ALL.ATTRIBUTE7 ATTRIBUTE7, PO_LINE_LOCATIONS_ALL.ATTRIBUTE8 ATTRIBUTE8, PO_LINE_LOCATIONS_ALL.ATTRIBUTE9 ATTRIBUTE9, PO_LINE_LOCATIONS_ALL.ATTRIBUTE10 ATTRIBUTE10, PO_LINE_LOCATIONS_ALL.ENCUMBER_NOW ENCUMBER_NOW, PO_LINE_LOCATIONS_ALL.ATTRIBUTE11 ATTRIBUTE11, PO_LINE_LOCATIONS_ALL.ATTRIBUTE12 ATTRIBUTE12, PO_LINE_LOCATIONS_ALL.ATTRIBUTE13 ATTRIBUTE13, PO_LINE_LOCATIONS_ALL.ATTRIBUTE14 ATTRIBUTE14, PO_LINE_LOCATIONS_ALL.ATTRIBUTE15 ATTRIBUTE15, PO_LINE_LOCATIONS_ALL.ATTRIBUTE16 ATTRIBUTE16, PO_LINE_LOCATIONS_ALL.ATTRIBUTE17 ATTRIBUTE17, PO_LINE_LOCATIONS_ALL.ATTRIBUTE18 ATTRIBUTE18, PO_LINE_LOCATIONS_ALL.ATTRIBUTE19 ATTRIBUTE19, PO_LINE_LOCATIONS_ALL.ATTRIBUTE20 ATTRIBUTE20, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE6 ATTRIBUTE_DATE6, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE7 ATTRIBUTE_DATE7, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE8 ATTRIBUTE_DATE8, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE9 ATTRIBUTE_DATE9, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE10 ATTRIBUTE_DATE10, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP6, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP7, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP8, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP9, PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_TIMESTAMP10, PO_LINE_LOCATIONS_ALL.INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG, PO_LINE_LOCATIONS_ALL.RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG, PO_LINE_LOCATIONS_ALL.QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE, PO_LINE_LOCATIONS_ALL.QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE, PO_LINE_LOCATIONS_ALL.ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE, PO_LINE_LOCATIONS_ALL.ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG, PO_LINE_LOCATIONS_ALL.DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED, PO_LINE_LOCATIONS_ALL.DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED, PO_LINE_LOCATIONS_ALL.RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE, PO_LINE_LOCATIONS_ALL.INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE, PO_LINE_LOCATIONS_ALL.RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE, PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM SHIPMENT_NUM, PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID, PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE SHIPMENT_TYPE, PO_LINE_LOCATIONS_ALL.REQUEST_ID REQUEST_ID, PO_LINE_LOCATIONS_ALL.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, PO_LINE_LOCATIONS_ALL.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, PO_LINE_LOCATIONS_ALL.PROGRAM_NAME PROGRAM_NAME, PO_LINE_LOCATIONS_ALL.PROGRAM_APP_NAME PROGRAM_APP_NAME, PO_LINE_LOCATIONS_ALL.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, PO_LINE_LOCATIONS_ALL.RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID, PO_LINE_LOCATIONS_ALL.ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG, PO_LINE_LOCATIONS_ALL.CLOSED_REASON CLOSED_REASON, PO_LINE_LOCATIONS_ALL.CLOSED_DATE CLOSED_DATE, PO_LINE_LOCATIONS_ALL.CLOSED_BY CLOSED_BY, PO_LINE_LOCATIONS_ALL.SOLDTO_BU_ID SOLDTO_BU_ID, PO_LINE_LOCATIONS_ALL.QUANTITY_SHIPPED PRICING_QUANTITY_SHIPPED, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE1, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE2, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE3, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE4, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_DATE5, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER1, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER2, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER3, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER4, PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_NUMBER5, PO_LINE_LOCATIONS_ALL.COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE, PO_LINE_LOCATIONS_ALL.TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG, PO_LINE_LOCATIONS_ALL.MATCH_OPTION MATCH_OPTION, PO_LINE_LOCATIONS_ALL.TAX_CODE_ID TAX_CODE_ID, PO_LINE_LOCATIONS_ALL.CALCULATE_TAX_FLAG CALCULATE_TAX_FLAG, PO_LINE_LOCATIONS_ALL.CHANGE_PROMISED_DATE_REASON CHANGE_PROMISED_DATE_REASON, PO_LINE_LOCATIONS_ALL.NOTE_TO_RECEIVER NOTE_TO_RECEIVER, PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY SECONDARY_QUANTITY, PO_LINE_LOCATIONS_ALL.PREFERRED_GRADE PREFERRED_GRADE, PO_LINE_LOCATIONS_ALL.SECONDARY_UOM_CODE SECONDARY_UOM_CODE, PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY_RECEIVED SECONDARY_QUANTITY_RECEIVED, PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY_ACCEPTED SECONDARY_QUANTITY_ACCEPTED, PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY_REJECTED SECONDARY_QUANTITY_REJECTED, PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY_CANCELLED SECONDARY_QUANTITY_CANCELLED, PO_LINE_LOCATIONS_ALL.VMI_FLAG VMI_FLAG, PO_LINE_LOCATIONS_ALL.CONSIGNED_FLAG CONSIGNED_FLAG, PO_LINE_LOCATIONS_ALL.RETROACTIVE_DATE RETROACTIVE_DATE, PO_LINE_LOCATIONS_ALL.SUPPLIER_ORDER_LINE_NUMBER SUPPLIER_ORDER_LINE_NUMBER, PO_LINE_LOCATIONS_ALL.AMOUNT AMOUNT, PO_LINE_LOCATIONS_ALL.AMOUNT_RECEIVED AMOUNT_RECEIVED, PO_LINE_LOCATIONS_ALL.AMOUNT_BILLED AMOUNT_BILLED, PO_LINE_LOCATIONS_ALL.AMOUNT_CANCELLED AMOUNT_CANCELLED, PO_LINE_LOCATIONS_ALL.AMOUNT_REJECTED AMOUNT_REJECTED, PO_LINE_LOCATIONS_ALL.AMOUNT_ACCEPTED AMOUNT_ACCEPTED, PO_LINE_LOCATIONS_ALL.DROP_SHIP_FLAG DROP_SHIP_FLAG, PO_LINE_LOCATIONS_ALL.SALES_ORDER_UPDATE_DATE SALES_ORDER_UPDATE_DATE, PO_LINE_LOCATIONS_ALL.TRANSACTION_FLOW_HEADER_ID TRANSACTION_FLOW_HEADER_ID, PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY_SHIPPED SECONDARY_QUANTITY_SHIPPED, PO_LINE_LOCATIONS_ALL.FINAL_MATCH_FLAG FINAL_MATCH_FLAG, PO_LINE_LOCATIONS_ALL.MANUAL_PRICE_CHANGE_FLAG MANUAL_PRICE_CHANGE_FLAG, PO_LINE_LOCATIONS_ALL.SHIPMENT_CLOSED_DATE SHIPMENT_CLOSED_DATE, PO_LINE_LOCATIONS_ALL.CLOSED_FOR_RECEIVING_DATE CLOSED_FOR_RECEIVING_DATE, PO_LINE_LOCATIONS_ALL.CLOSED_FOR_INVOICE_DATE CLOSED_FOR_INVOICE_DATE, PO_LINE_LOCATIONS_ALL.VALUE_BASIS VALUE_BASIS, PO_LINE_LOCATIONS_ALL.MATCHING_BASIS MATCHING_BASIS, PO_LINE_LOCATIONS_ALL.PAYMENT_TYPE PAYMENT_TYPE, PO_LINE_LOCATIONS_ALL.GROUP_NAME GROUP_NAME, PO_LINE_LOCATIONS_ALL.DESCRIPTION DESCRIPTION, PO_LINE_LOCATIONS_ALL.WORK_APPROVER_ID WORK_APPROVER_ID, PO_LINE_LOCATIONS_ALL.BID_PAYMENT_ID BID_PAYMENT_ID, PO_LINE_LOCATIONS_ALL.QUANTITY_FINANCED QUANTITY_FINANCED, PO_LINE_LOCATIONS_ALL.AMOUNT_FINANCED AMOUNT_FINANCED, PO_LINE_LOCATIONS_ALL.QUANTITY_RECOUPED QUANTITY_RECOUPED, PO_LINE_LOCATIONS_ALL.AMOUNT_RECOUPED AMOUNT_RECOUPED, PO_LINE_LOCATIONS_ALL.RETAINAGE_WITHHELD_AMOUNT RETAINAGE_WITHHELD_AMOUNT, PO_LINE_LOCATIONS_ALL.RETAINAGE_RELEASED_AMOUNT RETAINAGE_RELEASED_AMOUNT, PO_LINE_LOCATIONS_ALL.AMOUNT_SHIPPED AMOUNT_SHIPPED, PO_LINE_LOCATIONS_ALL.OUTSOURCED_ASSEMBLY OUTSOURCED_ASSEMBLY, PO_LINE_LOCATIONS_ALL.TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE, PO_LINE_LOCATIONS_ALL.ORIGINAL_SHIPMENT_ID ORIGINAL_SHIPMENT_ID, PO_LINE_LOCATIONS_ALL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PO_LINE_LOCATIONS_ALL.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY, PO_LINE_LOCATIONS_ALL.ORIG_SCHEDULE_STATUS ORIG_SCHEDULE_STATUS, PO_LINE_LOCATIONS_ALL.PRODUCT_FISC_CLASS_ID PRODUCT_FISC_CLASS_ID, PO_LINE_LOCATIONS_ALL.LINE_INTENDED_USE_ID LINE_INTENDED_USE_ID, PO_LINE_LOCATIONS_ALL.EXTERNAL_SYS_RCV_INTF_STATUS EXTERNAL_SYS_RCV_INTF_STATUS, PO_LINE_LOCATIONS_ALL.BACK_TO_BACK_FLAG BACK_TO_BACK_FLAG, PO_LINE_LOCATIONS_ALL.CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER, PO_LINE_LOCATIONS_ALL.CUSTOMER_PO_LINE_NUMBER CUSTOMER_PO_LINE_NUMBER, PO_LINE_LOCATIONS_ALL.CUSTOMER_PO_SCHEDULE_NUMBER CUSTOMER_PO_SCHEDULE_NUMBER, PO_LINE_LOCATIONS_ALL.CUSTOMER_ITEM CUSTOMER_ITEM, PO_LINE_LOCATIONS_ALL.CUSTOMER_ITEM_DESC CUSTOMER_ITEM_DESC, PO_LINE_LOCATIONS_ALL.SALES_ORDER_NUMBER SALES_ORDER_NUMBER, PO_LINE_LOCATIONS_ALL.SALES_ORDER_LINE_NUMBER SALES_ORDER_LINE_NUMBER, PO_LINE_LOCATIONS_ALL.SALES_ORDER_SCHEDULE_NUMBER SALES_ORDER_SCHEDULE_NUMBER, PO_LINE_LOCATIONS_ALL.SHIP_TO_CUST_LOCATION_ID SHIP_TO_CUST_LOCATION_ID, PO_LINE_LOCATIONS_ALL.SHIP_TO_CUST_ID SHIP_TO_CUST_ID, PO_LINE_LOCATIONS_ALL.SHIP_TO_CUST_CONTACT_ID SHIP_TO_CUST_CONTACT_ID, PO_LINE_LOCATIONS_ALL.CANCEL_BUDGET_DATE_OPTION CANCEL_BUDGET_DATE_OPTION, PO_LINE_LOCATIONS_ALL.REINSTATE_BUDGET_DATE_OPTION REINSTATE_BUDGET_DATE_OPTION, PO_LINE_LOCATIONS_ALL.CANCEL_BUDGET_DATE CANCEL_BUDGET_DATE, PO_LINE_LOCATIONS_ALL.REINSTATE_BUDGET_DATE REINSTATE_BUDGET_DATE, PO_LINE_LOCATIONS_ALL.FINAL_DISCHARGE_LOCATION_ID FINAL_DISCHARGE_LOCATION_ID, PO_LINE_LOCATIONS_ALL.REOPEN_FINAL_CLOSE_DATE REOPEN_FINAL_CLOSE_DATE, PO_LINE_LOCATIONS_ALL.WORK_ORDER_ID WORK_ORDER_ID, PO_LINE_LOCATIONS_ALL.WORK_ORDER_NUMBER WORK_ORDER_NUMBER, PO_LINE_LOCATIONS_ALL.ANTICIPATED_ARRIVAL_DATE ANTICIPATED_ARRIVAL_DATE, PO_LINE_LOCATIONS_ALL.DELIVERY_DATE_CONFIRMATION_REQ DELIVERY_DATE_CONFIRMATION_REQ, PO_LINE_LOCATIONS_ALL.TAX_EXCLUSIVE_PRICE TAX_EXCLUSIVE_PRICE, PO_LINE_LOCATIONS_ALL.EXTERNAL_SYS_RCV_GROUP_ID EXTERNAL_SYS_RCV_GROUP_ID, PO_LINE_LOCATIONS_ALL.RETAINAGE_RATE RETAINAGE_RATE, PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_CODE UOM_CODE, PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY_RECEIVED QUANTITY_RECEIVED, PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY_ACCEPTED QUANTITY_ACCEPTED, PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY_REJECTED QUANTITY_REJECTED, PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY_SHIPPED QUANTITY_SHIPPED, PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY_CANCELED QUANTITY_CANCELLED, PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY QUANTITY FROM PO_LINE_LOCATIONS_ALL

SQL_Statement

SELECT

PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID LINE_LOCATION_ID,

PO_LINE_LOCATIONS_ALL.WORK_ORDER_SUB_TYPE WORK_ORDER_SUB_TYPE,

PO_LINE_LOCATIONS_ALL.WORK_ORDER_OPERATION_SEQ WORK_ORDER_OPERATION_SEQ,

PO_LINE_LOCATIONS_ALL.WORK_ORDER_OPERATION_ID WORK_ORDER_OPERATION_ID,

PO_LINE_LOCATIONS_ALL.EXTERNAL_SYS_RCV_INTF_CO_SEQ EXTERNAL_SYS_RCV_INTF_CO_SEQ,

PO_LINE_LOCATIONS_ALL.FIRM_FLAG FIRM_FLAG,

PO_LINE_LOCATIONS_ALL.ORCHESTRATION_CODE ORCHESTRATION_CODE,

PO_LINE_LOCATIONS_ALL.MODE_OF_TRANSPORT MODE_OF_TRANSPORT,

PO_LINE_LOCATIONS_ALL.SERVICE_LEVEL SERVICE_LEVEL,

PO_LINE_LOCATIONS_ALL.REQUESTED_SHIP_DATE REQUESTED_SHIP_DATE,

PO_LINE_LOCATIONS_ALL.PROMISED_SHIP_DATE PROMISED_SHIP_DATE,

PO_LINE_LOCATIONS_ALL.FUNDS_STATUS FUNDS_STATUS,

PO_LINE_LOCATIONS_ALL.SFO_PTR_ID SFO_PTR_ID,

PO_LINE_LOCATIONS_ALL.SFO_AGREEMENT_NUMBER SFO_AGREEMENT_NUMBER,

PO_LINE_LOCATIONS_ALL.SFO_AGREEMENT_LINE_NUMBER SFO_AGREEMENT_LINE_NUMBER,

PO_LINE_LOCATIONS_ALL.PO_TRADING_ORGANIZATION_ID PO_TRADING_ORGANIZATION_ID,

PO_LINE_LOCATIONS_ALL.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE,

PO_LINE_LOCATIONS_ALL.AUTO_CLOSURE_MODE AUTO_CLOSURE_MODE,

PO_LINE_LOCATIONS_ALL.SCHEDULE_STATUS SCHEDULE_STATUS,

PO_LINE_LOCATIONS_ALL.UNIT_OF_MEASURE_CLASS UNIT_OF_MEASURE_CLASS,

PO_LINE_LOCATIONS_ALL.TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY,

PO_LINE_LOCATIONS_ALL.PRODUCT_CATEGORY PRODUCT_CATEGORY,

PO_LINE_LOCATIONS_ALL.PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION,

PO_LINE_LOCATIONS_ALL.LINE_INTENDED_USE LINE_INTENDED_USE,

PO_LINE_LOCATIONS_ALL.PRC_BU_ID PRC_BU_ID,

PO_LINE_LOCATIONS_ALL.REQ_BU_ID REQ_BU_ID,

PO_LINE_LOCATIONS_ALL.PRODUCT_TYPE PRODUCT_TYPE,

PO_LINE_LOCATIONS_ALL.USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS,

PO_LINE_LOCATIONS_ALL.ASSESSABLE_VALUE ASSESSABLE_VALUE,

PO_LINE_LOCATIONS_ALL.INPUT_TAX_CLASSIFICATION_CODE INPUT_TAX_CLASSIFICATION_CODE,

PO_LINE_LOCATIONS_ALL.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PO_LINE_LOCATIONS_ALL.LAST_UPDATED_BY LAST_UPDATED_BY,

PO_LINE_LOCATIONS_ALL.PO_HEADER_ID PO_HEADER_ID,

PO_LINE_LOCATIONS_ALL.PO_LINE_ID PO_LINE_ID,

PO_LINE_LOCATIONS_ALL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PO_LINE_LOCATIONS_ALL.CREATION_DATE CREATION_DATE,

PO_LINE_LOCATIONS_ALL.CREATED_BY CREATED_BY,

PO_LINE_LOCATIONS_ALL.QUANTITY PRICING_QUANTITY,

PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED PRICING_QUANTITY_RECEIVED,

PO_LINE_LOCATIONS_ALL.QUANTITY_ACCEPTED PRICING_QUANTITY_ACCEPTED,

PO_LINE_LOCATIONS_ALL.QUANTITY_REJECTED PRICING_QUANTITY_REJECTED,

PO_LINE_LOCATIONS_ALL.QUANTITY_BILLED QUANTITY_BILLED,

PO_LINE_LOCATIONS_ALL.QUANTITY_CANCELLED PRICING_QUANTITY_CANCELLED,

PO_LINE_LOCATIONS_ALL.UOM_CODE PRICING_UOM_CODE,

PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID,

PO_LINE_LOCATIONS_ALL.CARRIER_ID CARRIER_ID,

PO_LINE_LOCATIONS_ALL.NEED_BY_DATE NEED_BY_DATE,

PO_LINE_LOCATIONS_ALL.PROMISED_DATE PROMISED_DATE,

PO_LINE_LOCATIONS_ALL.LAST_ACCEPT_DATE LAST_ACCEPT_DATE,

PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE PRICE_OVERRIDE,

PO_LINE_LOCATIONS_ALL.ENCUMBERED_FLAG ENCUMBERED_FLAG,

PO_LINE_LOCATIONS_ALL.ENCUMBERED_DATE ENCUMBERED_DATE,

PO_LINE_LOCATIONS_ALL.UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY,

PO_LINE_LOCATIONS_ALL.FOB_LOOKUP_CODE FOB_LOOKUP_CODE,

PO_LINE_LOCATIONS_ALL.FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE,

PO_LINE_LOCATIONS_ALL.TAXABLE_FLAG TAXABLE_FLAG,

PO_LINE_LOCATIONS_ALL.TAX_NAME TAX_NAME,

PO_LINE_LOCATIONS_ALL.ESTIMATED_TAX_AMOUNT ESTIMATED_TAX_AMOUNT,

PO_LINE_LOCATIONS_ALL.FROM_HEADER_ID FROM_HEADER_ID,

PO_LINE_LOCATIONS_ALL.FROM_LINE_ID FROM_LINE_ID,

PO_LINE_LOCATIONS_ALL.FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID,

PO_LINE_LOCATIONS_ALL.START_DATE START_DATE,

PO_LINE_LOCATIONS_ALL.END_DATE END_DATE,

PO_LINE_LOCATIONS_ALL.LEAD_TIME LEAD_TIME,

PO_LINE_LOCATIONS_ALL.LEAD_TIME_UNIT LEAD_TIME_UNIT,

PO_LINE_LOCATIONS_ALL.PRICE_DISCOUNT PRICE_DISCOUNT,

PO_LINE_LOCATIONS_ALL.TERMS_ID TERMS_ID,

PO_LINE_LOCATIONS_ALL.CANCEL_FLAG CANCEL_FLAG,

PO_LINE_LOCATIONS_ALL.CANCELLED_BY CANCELLED_BY,

PO_LINE_LOCATIONS_ALL.CANCEL_DATE CANCEL_DATE,

PO_LINE_LOCATIONS_ALL.CANCEL_REASON CANCEL_REASON,

PO_LINE_LOCATIONS_ALL.FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE,

PO_LINE_LOCATIONS_ALL.FIRM_DATE FIRM_DATE,

PO_LINE_LOCATIONS_ALL.FIRMED_BY FIRMED_BY,

PO_LINE_LOCATIONS_ALL.FIRM_REASON FIRM_REASON,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE1 ATTRIBUTE1,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE2 ATTRIBUTE2,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE3 ATTRIBUTE3,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE4 ATTRIBUTE4,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE5 ATTRIBUTE5,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE6 ATTRIBUTE6,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE7 ATTRIBUTE7,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE8 ATTRIBUTE8,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE9 ATTRIBUTE9,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE10 ATTRIBUTE10,

PO_LINE_LOCATIONS_ALL.ENCUMBER_NOW ENCUMBER_NOW,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE11 ATTRIBUTE11,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE12 ATTRIBUTE12,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE13 ATTRIBUTE13,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE14 ATTRIBUTE14,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE15 ATTRIBUTE15,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE16 ATTRIBUTE16,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE17 ATTRIBUTE17,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE18 ATTRIBUTE18,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE19 ATTRIBUTE19,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE20 ATTRIBUTE20,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE6 ATTRIBUTE_DATE6,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE7 ATTRIBUTE_DATE7,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE8 ATTRIBUTE_DATE8,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE9 ATTRIBUTE_DATE9,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_DATE10 ATTRIBUTE_DATE10,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP6,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP7,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP8,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP9,

PO_LINE_LOCATIONS_ALL.ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_TIMESTAMP10,

PO_LINE_LOCATIONS_ALL.INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG,

PO_LINE_LOCATIONS_ALL.RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG,

PO_LINE_LOCATIONS_ALL.QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE,

PO_LINE_LOCATIONS_ALL.QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE,

PO_LINE_LOCATIONS_ALL.ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE,

PO_LINE_LOCATIONS_ALL.ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG,

PO_LINE_LOCATIONS_ALL.DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED,

PO_LINE_LOCATIONS_ALL.DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED,

PO_LINE_LOCATIONS_ALL.RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE,

PO_LINE_LOCATIONS_ALL.INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE,

PO_LINE_LOCATIONS_ALL.RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE,

PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID,

PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM SHIPMENT_NUM,

PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID,

PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE SHIPMENT_TYPE,

PO_LINE_LOCATIONS_ALL.REQUEST_ID REQUEST_ID,

PO_LINE_LOCATIONS_ALL.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

PO_LINE_LOCATIONS_ALL.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

PO_LINE_LOCATIONS_ALL.PROGRAM_NAME PROGRAM_NAME,

PO_LINE_LOCATIONS_ALL.PROGRAM_APP_NAME PROGRAM_APP_NAME,

PO_LINE_LOCATIONS_ALL.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT,

PO_LINE_LOCATIONS_ALL.RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID,

PO_LINE_LOCATIONS_ALL.ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG,

PO_LINE_LOCATIONS_ALL.CLOSED_REASON CLOSED_REASON,

PO_LINE_LOCATIONS_ALL.CLOSED_DATE CLOSED_DATE,

PO_LINE_LOCATIONS_ALL.CLOSED_BY CLOSED_BY,

PO_LINE_LOCATIONS_ALL.SOLDTO_BU_ID SOLDTO_BU_ID,

PO_LINE_LOCATIONS_ALL.QUANTITY_SHIPPED PRICING_QUANTITY_SHIPPED,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE1,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE2,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE3,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE4,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_DATE5,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER1,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER2,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER3,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER4,

PO_LINE_LOCATIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_NUMBER5,

PO_LINE_LOCATIONS_ALL.COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE,

PO_LINE_LOCATIONS_ALL.TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG,

PO_LINE_LOCATIONS_ALL.MATCH_OPTION MATCH_OPTION,

PO_LINE_LOCATIONS_ALL.TAX_CODE_ID TAX_CODE_ID,

PO_LINE_LOCATIONS_ALL.CALCULATE_TAX_FLAG CALCULATE_TAX_FLAG,

PO_LINE_LOCATIONS_ALL.CHANGE_PROMISED_DATE_REASON CHANGE_PROMISED_DATE_REASON,

PO_LINE_LOCATIONS_ALL.NOTE_TO_RECEIVER NOTE_TO_RECEIVER,

PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY SECONDARY_QUANTITY,

PO_LINE_LOCATIONS_ALL.PREFERRED_GRADE PREFERRED_GRADE,

PO_LINE_LOCATIONS_ALL.SECONDARY_UOM_CODE SECONDARY_UOM_CODE,

PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY_RECEIVED SECONDARY_QUANTITY_RECEIVED,

PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY_ACCEPTED SECONDARY_QUANTITY_ACCEPTED,

PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY_REJECTED SECONDARY_QUANTITY_REJECTED,

PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY_CANCELLED SECONDARY_QUANTITY_CANCELLED,

PO_LINE_LOCATIONS_ALL.VMI_FLAG VMI_FLAG,

PO_LINE_LOCATIONS_ALL.CONSIGNED_FLAG CONSIGNED_FLAG,

PO_LINE_LOCATIONS_ALL.RETROACTIVE_DATE RETROACTIVE_DATE,

PO_LINE_LOCATIONS_ALL.SUPPLIER_ORDER_LINE_NUMBER SUPPLIER_ORDER_LINE_NUMBER,

PO_LINE_LOCATIONS_ALL.AMOUNT AMOUNT,

PO_LINE_LOCATIONS_ALL.AMOUNT_RECEIVED AMOUNT_RECEIVED,

PO_LINE_LOCATIONS_ALL.AMOUNT_BILLED AMOUNT_BILLED,

PO_LINE_LOCATIONS_ALL.AMOUNT_CANCELLED AMOUNT_CANCELLED,

PO_LINE_LOCATIONS_ALL.AMOUNT_REJECTED AMOUNT_REJECTED,

PO_LINE_LOCATIONS_ALL.AMOUNT_ACCEPTED AMOUNT_ACCEPTED,

PO_LINE_LOCATIONS_ALL.DROP_SHIP_FLAG DROP_SHIP_FLAG,

PO_LINE_LOCATIONS_ALL.SALES_ORDER_UPDATE_DATE SALES_ORDER_UPDATE_DATE,

PO_LINE_LOCATIONS_ALL.TRANSACTION_FLOW_HEADER_ID TRANSACTION_FLOW_HEADER_ID,

PO_LINE_LOCATIONS_ALL.SECONDARY_QUANTITY_SHIPPED SECONDARY_QUANTITY_SHIPPED,

PO_LINE_LOCATIONS_ALL.FINAL_MATCH_FLAG FINAL_MATCH_FLAG,

PO_LINE_LOCATIONS_ALL.MANUAL_PRICE_CHANGE_FLAG MANUAL_PRICE_CHANGE_FLAG,

PO_LINE_LOCATIONS_ALL.SHIPMENT_CLOSED_DATE SHIPMENT_CLOSED_DATE,

PO_LINE_LOCATIONS_ALL.CLOSED_FOR_RECEIVING_DATE CLOSED_FOR_RECEIVING_DATE,

PO_LINE_LOCATIONS_ALL.CLOSED_FOR_INVOICE_DATE CLOSED_FOR_INVOICE_DATE,

PO_LINE_LOCATIONS_ALL.VALUE_BASIS VALUE_BASIS,

PO_LINE_LOCATIONS_ALL.MATCHING_BASIS MATCHING_BASIS,

PO_LINE_LOCATIONS_ALL.PAYMENT_TYPE PAYMENT_TYPE,

PO_LINE_LOCATIONS_ALL.GROUP_NAME GROUP_NAME,

PO_LINE_LOCATIONS_ALL.DESCRIPTION DESCRIPTION,

PO_LINE_LOCATIONS_ALL.WORK_APPROVER_ID WORK_APPROVER_ID,

PO_LINE_LOCATIONS_ALL.BID_PAYMENT_ID BID_PAYMENT_ID,

PO_LINE_LOCATIONS_ALL.QUANTITY_FINANCED QUANTITY_FINANCED,

PO_LINE_LOCATIONS_ALL.AMOUNT_FINANCED AMOUNT_FINANCED,

PO_LINE_LOCATIONS_ALL.QUANTITY_RECOUPED QUANTITY_RECOUPED,

PO_LINE_LOCATIONS_ALL.AMOUNT_RECOUPED AMOUNT_RECOUPED,

PO_LINE_LOCATIONS_ALL.RETAINAGE_WITHHELD_AMOUNT RETAINAGE_WITHHELD_AMOUNT,

PO_LINE_LOCATIONS_ALL.RETAINAGE_RELEASED_AMOUNT RETAINAGE_RELEASED_AMOUNT,

PO_LINE_LOCATIONS_ALL.AMOUNT_SHIPPED AMOUNT_SHIPPED,

PO_LINE_LOCATIONS_ALL.OUTSOURCED_ASSEMBLY OUTSOURCED_ASSEMBLY,

PO_LINE_LOCATIONS_ALL.TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE,

PO_LINE_LOCATIONS_ALL.ORIGINAL_SHIPMENT_ID ORIGINAL_SHIPMENT_ID,

PO_LINE_LOCATIONS_ALL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PO_LINE_LOCATIONS_ALL.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY,

PO_LINE_LOCATIONS_ALL.ORIG_SCHEDULE_STATUS ORIG_SCHEDULE_STATUS,

PO_LINE_LOCATIONS_ALL.PRODUCT_FISC_CLASS_ID PRODUCT_FISC_CLASS_ID,

PO_LINE_LOCATIONS_ALL.LINE_INTENDED_USE_ID LINE_INTENDED_USE_ID,

PO_LINE_LOCATIONS_ALL.EXTERNAL_SYS_RCV_INTF_STATUS EXTERNAL_SYS_RCV_INTF_STATUS,

PO_LINE_LOCATIONS_ALL.BACK_TO_BACK_FLAG BACK_TO_BACK_FLAG,

PO_LINE_LOCATIONS_ALL.CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER,

PO_LINE_LOCATIONS_ALL.CUSTOMER_PO_LINE_NUMBER CUSTOMER_PO_LINE_NUMBER,

PO_LINE_LOCATIONS_ALL.CUSTOMER_PO_SCHEDULE_NUMBER CUSTOMER_PO_SCHEDULE_NUMBER,

PO_LINE_LOCATIONS_ALL.CUSTOMER_ITEM CUSTOMER_ITEM,

PO_LINE_LOCATIONS_ALL.CUSTOMER_ITEM_DESC CUSTOMER_ITEM_DESC,

PO_LINE_LOCATIONS_ALL.SALES_ORDER_NUMBER SALES_ORDER_NUMBER,

PO_LINE_LOCATIONS_ALL.SALES_ORDER_LINE_NUMBER SALES_ORDER_LINE_NUMBER,

PO_LINE_LOCATIONS_ALL.SALES_ORDER_SCHEDULE_NUMBER SALES_ORDER_SCHEDULE_NUMBER,

PO_LINE_LOCATIONS_ALL.SHIP_TO_CUST_LOCATION_ID SHIP_TO_CUST_LOCATION_ID,

PO_LINE_LOCATIONS_ALL.SHIP_TO_CUST_ID SHIP_TO_CUST_ID,

PO_LINE_LOCATIONS_ALL.SHIP_TO_CUST_CONTACT_ID SHIP_TO_CUST_CONTACT_ID,

PO_LINE_LOCATIONS_ALL.CANCEL_BUDGET_DATE_OPTION CANCEL_BUDGET_DATE_OPTION,

PO_LINE_LOCATIONS_ALL.REINSTATE_BUDGET_DATE_OPTION REINSTATE_BUDGET_DATE_OPTION,

PO_LINE_LOCATIONS_ALL.CANCEL_BUDGET_DATE CANCEL_BUDGET_DATE,

PO_LINE_LOCATIONS_ALL.REINSTATE_BUDGET_DATE REINSTATE_BUDGET_DATE,

PO_LINE_LOCATIONS_ALL.FINAL_DISCHARGE_LOCATION_ID FINAL_DISCHARGE_LOCATION_ID,

PO_LINE_LOCATIONS_ALL.REOPEN_FINAL_CLOSE_DATE REOPEN_FINAL_CLOSE_DATE,

PO_LINE_LOCATIONS_ALL.WORK_ORDER_ID WORK_ORDER_ID,

PO_LINE_LOCATIONS_ALL.WORK_ORDER_NUMBER WORK_ORDER_NUMBER,

PO_LINE_LOCATIONS_ALL.ANTICIPATED_ARRIVAL_DATE ANTICIPATED_ARRIVAL_DATE,

PO_LINE_LOCATIONS_ALL.DELIVERY_DATE_CONFIRMATION_REQ DELIVERY_DATE_CONFIRMATION_REQ,

PO_LINE_LOCATIONS_ALL.TAX_EXCLUSIVE_PRICE TAX_EXCLUSIVE_PRICE,

PO_LINE_LOCATIONS_ALL.EXTERNAL_SYS_RCV_GROUP_ID EXTERNAL_SYS_RCV_GROUP_ID,

PO_LINE_LOCATIONS_ALL.RETAINAGE_RATE RETAINAGE_RATE,

PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_CODE UOM_CODE,

PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY_RECEIVED QUANTITY_RECEIVED,

PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY_ACCEPTED QUANTITY_ACCEPTED,

PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY_REJECTED QUANTITY_REJECTED,

PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY_SHIPPED QUANTITY_SHIPPED,

PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY_CANCELED QUANTITY_CANCELLED,

PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY QUANTITY

FROM

PO_LINE_LOCATIONS_ALL