[Home] [Help] [Dependency Information]
Object Name: | PO_LINE_LOCATIONS_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_LINE_LOCATION_ID | NUMBER | Yes | ||
INTERFACE_HEADER_ID | NUMBER | Yes | ||
INTERFACE_LINE_ID | NUMBER | Yes | ||
PROCESSING_ID | NUMBER | |||
PROCESS_CODE | VARCHAR2 | (25) | ||
LINE_LOCATION_ID | NUMBER | |||
SHIPMENT_TYPE | VARCHAR2 | (25) | ||
SHIPMENT_NUM | NUMBER | |||
SHIP_TO_ORGANIZATION_ID | NUMBER | |||
SHIP_TO_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
SHIP_TO_LOCATION_ID | NUMBER | |||
SHIP_TO_LOCATION | VARCHAR2 | (60) | ||
TERMS_ID | NUMBER | |||
PAYMENT_TERMS | VARCHAR2 | (50) | ||
QTY_RCV_EXCEPTION_CODE | VARCHAR2 | (25) | ||
FREIGHT_CARRIER | VARCHAR2 | (80) | ||
FOB | VARCHAR2 | (25) | ||
FREIGHT_TERMS | VARCHAR2 | (25) | ||
ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | (25) | ||
ALLOW_SUBSTITUTE_RECEIPTS_FLAG | VARCHAR2 | (1) | ||
DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | |||
DAYS_LATE_RECEIPT_ALLOWED | NUMBER | |||
RECEIPT_DAYS_EXCEPTION_CODE | VARCHAR2 | (25) | ||
INVOICE_CLOSE_TOLERANCE | NUMBER | |||
RECEIVE_CLOSE_TOLERANCE | NUMBER | |||
RECEIVING_ROUTING_ID | NUMBER | |||
RECEIVING_ROUTING | VARCHAR2 | (30) | ||
ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | (1) | ||
FIRM_FLAG | VARCHAR2 | (25) | ||
NEED_BY_DATE | DATE | |||
PROMISED_DATE | DATE | |||
FROM_LINE_LOCATION_ID | NUMBER | |||
INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | ||
RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | ||
SOURCE_SHIPMENT_ID | NUMBER | |||
NOTE_TO_RECEIVER | VARCHAR2 | (480) | ||
TRANSACTION_FLOW_HEADER_ID | NUMBER | |||
QUANTITY | NUMBER | |||
PRICE_DISCOUNT | NUMBER | |||
START_DATE | DATE | |||
END_DATE | DATE | |||
PRICE_OVERRIDE | NUMBER | |||
LEAD_TIME | NUMBER | |||
LEAD_TIME_UNIT | VARCHAR2 | (25) | ||
AMOUNT | NUMBER | |||
SECONDARY_QUANTITY | NUMBER | |||
SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
PAYMENT_TYPE | VARCHAR2 | (30) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
WORK_APPROVER_ID | NUMBER | |||
AUCTION_PAYMENT_ID | NUMBER | |||
BID_PAYMENT_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER | |||
AWARD_ID | VARCHAR2 | (240) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_ORGANIZATION_ID | NUMBER | |||
EXPENDITURE_ITEM_DATE | DATE | |||
VALUE_BASIS | VARCHAR2 | (25) | ||
MATCHING_BASIS | VARCHAR2 | (30) | ||
PREFERRED_GRADE | VARCHAR2 | (150) | ||
TAX_CODE_ID | NUMBER | (15) | ||
TAX_NAME | VARCHAR2 | (30) | ||
TAXABLE_FLAG | VARCHAR2 | (1) | ||
QTY_RCV_TOLERANCE | NUMBER | |||
CLM_DELIVERY_PERIOD | NUMBER | |||
CLM_DELIVERY_PERIOD_UOM | VARCHAR2 | (25) | ||
CLM_POP_DURATION | NUMBER | |||
CLM_POP_DURATION_UOM | VARCHAR2 | (25) | ||
CLM_PROMISE_PERIOD | NUMBER | |||
CLM_PROMISE_PERIOD_UOM | VARCHAR2 | (25) |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_LINE_LOCATION_ID
, INTERFACE_HEADER_ID
, INTERFACE_LINE_ID
, PROCESSING_ID
, PROCESS_CODE
, LINE_LOCATION_ID
, SHIPMENT_TYPE
, SHIPMENT_NUM
, SHIP_TO_ORGANIZATION_ID
, SHIP_TO_ORGANIZATION_CODE
, SHIP_TO_LOCATION_ID
, SHIP_TO_LOCATION
, TERMS_ID
, PAYMENT_TERMS
, QTY_RCV_EXCEPTION_CODE
, FREIGHT_CARRIER
, FOB
, FREIGHT_TERMS
, 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
, RECEIVING_ROUTING_ID
, RECEIVING_ROUTING
, ACCRUE_ON_RECEIPT_FLAG
, FIRM_FLAG
, NEED_BY_DATE
, PROMISED_DATE
, FROM_LINE_LOCATION_ID
, INSPECTION_REQUIRED_FLAG
, RECEIPT_REQUIRED_FLAG
, SOURCE_SHIPMENT_ID
, NOTE_TO_RECEIVER
, TRANSACTION_FLOW_HEADER_ID
, QUANTITY
, PRICE_DISCOUNT
, START_DATE
, END_DATE
, PRICE_OVERRIDE
, LEAD_TIME
, LEAD_TIME_UNIT
, AMOUNT
, SECONDARY_QUANTITY
, SECONDARY_UNIT_OF_MEASURE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, UNIT_OF_MEASURE
, PAYMENT_TYPE
, DESCRIPTION
, WORK_APPROVER_ID
, AUCTION_PAYMENT_ID
, BID_PAYMENT_ID
, PROJECT_ID
, TASK_ID
, AWARD_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ITEM_DATE
, VALUE_BASIS
, MATCHING_BASIS
, PREFERRED_GRADE
, TAX_CODE_ID
, TAX_NAME
, TAXABLE_FLAG
, QTY_RCV_TOLERANCE
, CLM_DELIVERY_PERIOD
, CLM_DELIVERY_PERIOD_UOM
, CLM_POP_DURATION
, CLM_POP_DURATION_UOM
, CLM_PROMISE_PERIOD
, CLM_PROMISE_PERIOD_UOM
FROM PO.PO_LINE_LOCATIONS_INTERFACE#;
|
|
|