VIEW: PO.PO_LINE_LOCATIONS_INTERFACE#

Source

View Text - Preformatted

select INTERFACE_LINE_LOCATION_ID INTERFACE_LINE_LOCATION_ID, INTERFACE_HEADER_ID INTERFACE_HEADER_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, PROCESSING_ID PROCESSING_ID, PROCESS_CODE PROCESS_CODE, LINE_LOCATION_ID LINE_LOCATION_ID, SHIPMENT_TYPE SHIPMENT_TYPE, SHIPMENT_NUM SHIPMENT_NUM, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, SHIP_TO_ORGANIZATION_CODE SHIP_TO_ORGANIZATION_CODE, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, SHIP_TO_LOCATION SHIP_TO_LOCATION, TERMS_ID TERMS_ID, PAYMENT_TERMS PAYMENT_TERMS, QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE, FREIGHT_CARRIER FREIGHT_CARRIER, FOB FOB, FREIGHT_TERMS FREIGHT_TERMS, 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, RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID, RECEIVING_ROUTING RECEIVING_ROUTING, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG, FIRM_FLAG FIRM_FLAG, NEED_BY_DATE NEED_BY_DATE, PROMISED_DATE PROMISED_DATE, FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID, INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG, RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG, SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID, NOTE_TO_RECEIVER NOTE_TO_RECEIVER, TRANSACTION_FLOW_HEADER_ID TRANSACTION_FLOW_HEADER_ID, QUANTITY QUANTITY, PRICE_DISCOUNT PRICE_DISCOUNT, START_DATE START_DATE, END_DATE END_DATE, PRICE_OVERRIDE PRICE_OVERRIDE, LEAD_TIME LEAD_TIME, LEAD_TIME_UNIT LEAD_TIME_UNIT, AMOUNT AMOUNT, SECONDARY_QUANTITY SECONDARY_QUANTITY, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, UNIT_OF_MEASURE UNIT_OF_MEASURE, PAYMENT_TYPE PAYMENT_TYPE, DESCRIPTION DESCRIPTION, WORK_APPROVER_ID WORK_APPROVER_ID, AUCTION_PAYMENT_ID AUCTION_PAYMENT_ID, BID_PAYMENT_ID BID_PAYMENT_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, AWARD_ID AWARD_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, VALUE_BASIS VALUE_BASIS, MATCHING_BASIS MATCHING_BASIS, PREFERRED_GRADE PREFERRED_GRADE, TAX_CODE_ID TAX_CODE_ID, TAX_NAME TAX_NAME, TAXABLE_FLAG TAXABLE_FLAG, QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE, 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_INTERFACE"

View Text - HTML Formatted

SELECT INTERFACE_LINE_LOCATION_ID INTERFACE_LINE_LOCATION_ID
, INTERFACE_HEADER_ID INTERFACE_HEADER_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, PROCESSING_ID PROCESSING_ID
, PROCESS_CODE PROCESS_CODE
, LINE_LOCATION_ID LINE_LOCATION_ID
, SHIPMENT_TYPE SHIPMENT_TYPE
, SHIPMENT_NUM SHIPMENT_NUM
, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID
, SHIP_TO_ORGANIZATION_CODE SHIP_TO_ORGANIZATION_CODE
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, SHIP_TO_LOCATION SHIP_TO_LOCATION
, TERMS_ID TERMS_ID
, PAYMENT_TERMS PAYMENT_TERMS
, QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE
, FREIGHT_CARRIER FREIGHT_CARRIER
, FOB FOB
, FREIGHT_TERMS FREIGHT_TERMS
, 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
, RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID
, RECEIVING_ROUTING RECEIVING_ROUTING
, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG
, FIRM_FLAG FIRM_FLAG
, NEED_BY_DATE NEED_BY_DATE
, PROMISED_DATE PROMISED_DATE
, FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID
, INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG
, RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG
, SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID
, NOTE_TO_RECEIVER NOTE_TO_RECEIVER
, TRANSACTION_FLOW_HEADER_ID TRANSACTION_FLOW_HEADER_ID
, QUANTITY QUANTITY
, PRICE_DISCOUNT PRICE_DISCOUNT
, START_DATE START_DATE
, END_DATE END_DATE
, PRICE_OVERRIDE PRICE_OVERRIDE
, LEAD_TIME LEAD_TIME
, LEAD_TIME_UNIT LEAD_TIME_UNIT
, AMOUNT AMOUNT
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, PAYMENT_TYPE PAYMENT_TYPE
, DESCRIPTION DESCRIPTION
, WORK_APPROVER_ID WORK_APPROVER_ID
, AUCTION_PAYMENT_ID AUCTION_PAYMENT_ID
, BID_PAYMENT_ID BID_PAYMENT_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, AWARD_ID AWARD_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, VALUE_BASIS VALUE_BASIS
, MATCHING_BASIS MATCHING_BASIS
, PREFERRED_GRADE PREFERRED_GRADE
, TAX_CODE_ID TAX_CODE_ID
, TAX_NAME TAX_NAME
, TAXABLE_FLAG TAXABLE_FLAG
, QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE
, 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_INTERFACE"