DBA Data[Home] [Help] [Dependency Information]

TABLE: PO.PO_LINE_LOCATIONS_INTERFACE

Object Details
Object Name: PO_LINE_LOCATIONS_INTERFACE
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_LINE_LOCATIONS_INTERFACE
Subobject Name:
Status: VALID


PO_LINE_LOCATIONS_INTERFACE is the interface table that holds line
locations information for the PDOI program to create standard/blanket
purchase orders and catalog quotations.
The PDOI program validates your data, derives or defaults additional
information and writes an error message for every validation that
fails into the PO_INTERFACE_ERRORS table.
Scope: public
Product: PO
Display Name: PO Lines Interface
Category: BUSINESS_ENTITY PO_BLANKET_PURCHASE_AGREEMENT
Category: BUSINESS_ENTITY PO_CONTRACT_PURCHASE_AGREEMENT
Category: BUSINESS_ENTITY PO_GLOBAL_BLANKET_AGREEMENT
Category: BUSINESS_ENTITY PO_GLOBAL_CONTRACT_AGREEMENT
Category: BUSINESS_ENTITY PO_PRICE_BREAKS
Category: BUSINESS_ENTITY PO_STANDARD_PURCHASE_ORDER


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_LINE_LOCATIONS_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTERFACE_LINE_LOCATION_ID
PO_LINE_LOCATIONS_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTERFACE_HEADER_ID
PO_LINE_LOCATIONS_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTERFACE_LINE_ID
PO_LINE_LOCATIONS_INTERFACE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESSING_ID
PO_LINE_LOCATIONS_INTERFACE_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_LOCATION_ID
Columns
Name Datatype Length Mandatory Comments
INTERFACE_LINE_LOCATION_ID NUMBER
Yes Interface line location unique identifier
INTERFACE_HEADER_ID NUMBER
Yes Interface header unique identifier
INTERFACE_LINE_ID NUMBER
Yes Interface line unique identifier
PROCESSING_ID NUMBER

Identifier for the line locations processed in current request
PROCESS_CODE VARCHAR2 (25)
Line status code for price/sales catalog update action (832 EDI transaction), such as NOTIFIED, ACCEPTED, or REJECTED
LINE_LOCATION_ID NUMBER

Document shipment schedule unique identifier
SHIPMENT_TYPE VARCHAR2 (25)
Type of shipment
SHIPMENT_NUM NUMBER

Document shipment number
SHIP_TO_ORGANIZATION_ID NUMBER

Ship-to organization unique identifier
SHIP_TO_ORGANIZATION_CODE VARCHAR2 (3)
Ship-to organization code
SHIP_TO_LOCATION_ID NUMBER

Ship-to location unique identifier
SHIP_TO_LOCATION VARCHAR2 (60)
Ship-to location
TERMS_ID NUMBER

Payment terms unique identifier
PAYMENT_TERMS VARCHAR2 (50)
Payment terms
QTY_RCV_EXCEPTION_CODE VARCHAR2 (25)
Action to be taken when the quantity received tolerance is exceeded
FREIGHT_CARRIER VARCHAR2 (80)
Type of carrier for the RFQ or quotation shipment
FOB VARCHAR2 (25)
Type of free-on-board terms for the shipment
FREIGHT_TERMS VARCHAR2 (25)
Type of freight terms for the RFQ or quotation shipment
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Describes what action is taken when the receiving location differs from the ship-to location
ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 (1)
Indicates whether substitute items can be received in place of the ordered items
DAYS_EARLY_RECEIPT_ALLOWED NUMBER

Maximum acceptable number of days items can be received early
DAYS_LATE_RECEIPT_ALLOWED NUMBER

Maximum acceptable number of days items can be received late
RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 (25)
Action to be taken when items are received earlier or later than the allowed number of days specified
INVOICE_CLOSE_TOLERANCE NUMBER

Percentage tolerance within which a shipment is automatically closed for invoicing when billed
RECEIVE_CLOSE_TOLERANCE NUMBER

Percentage tolerance within which a shipment is automatically closed for receiving
RECEIVING_ROUTING_ID NUMBER

Routing unique identifier
RECEIVING_ROUTING VARCHAR2 (30)
Routing
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
Indicates whether items are accrued upon receipt
FIRM_FLAG VARCHAR2 (25)
Indicates whether you want to prevent this purchase order from being automatically rescheduled by your manufacturing application
NEED_BY_DATE DATE

Date the goods are needed by
PROMISED_DATE DATE

Date the goods are promised by
FROM_LINE_LOCATION_ID NUMBER

Unique identifier of the RFQ shipment used to autocreate a quotation shipment
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether shipment must be inspected before the invoice is paid
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether shipment must be received before the invoice is paid
SOURCE_SHIPMENT_ID NUMBER

Source shipment for scheduled releases
NOTE_TO_RECEIVER VARCHAR2 (480)
Note to deliverer
TRANSACTION_FLOW_HEADER_ID NUMBER

Unique transaction flow identifier for relation between purchasing OU and ship to OU. This column is meant for Internal use only
QUANTITY NUMBER

Quantity ordered on shipment
PRICE_DISCOUNT NUMBER

Discount percentage for price break (applies to RFQs and quotations only)
START_DATE DATE

Effective date of the price break (applies to RFQs and quotations only)
END_DATE DATE

Expiration date of the price break (applies to RFQs and quotations only)
PRICE_OVERRIDE NUMBER

Order shipment price or break price for blanket purchase orders, RFQs, and quotations
LEAD_TIME NUMBER

Lead time for the price break (applies to RFQs and quotations only)
LEAD_TIME_UNIT VARCHAR2 (25)
Unit of measure for the lead time
AMOUNT NUMBER

Amount Ordered for Service line types
SECONDARY_QUANTITY NUMBER

Quantity ordered on shipment in secondary unit of measure
SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
Secondary unit of measure
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
UNIT_OF_MEASURE VARCHAR2 (25)
Unit of measure
PAYMENT_TYPE VARCHAR2 (30)
Type of Pay Item
DESCRIPTION VARCHAR2 (240)
Pay Item description
WORK_APPROVER_ID NUMBER

FND User ID of Work Confirmation Owner
AUCTION_PAYMENT_ID NUMBER

FK Reference to Pay Item in on the Sourcing Negotiation
BID_PAYMENT_ID NUMBER

Foreign Key reference to the Pay Item on the Sourcing Bid
PROJECT_ID NUMBER

Internal use only
TASK_ID NUMBER

Internal use only
AWARD_ID VARCHAR2 (240)
Internal use only
EXPENDITURE_TYPE VARCHAR2 (30)
Internal use only
EXPENDITURE_ORGANIZATION_ID NUMBER

Internal use only
EXPENDITURE_ITEM_DATE DATE

Internal use only
VALUE_BASIS VARCHAR2 (25)
Value Basis of the line location
MATCHING_BASIS VARCHAR2 (30)
Matching Basis for the line location
PREFERRED_GRADE VARCHAR2 (150)
Preferred Grade
TAX_CODE_ID NUMBER (15)
Unique identifier for the tax code
TAX_NAME VARCHAR2 (30)
Tax name (or Tax classification code)
TAXABLE_FLAG VARCHAR2 (1)
Indicate whether shipment is taxable
QTY_RCV_TOLERANCE NUMBER

Maximum over-receipt tolerance percentage
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)
Query Text

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;

Dependencies

[top of page]

PO.PO_LINE_LOCATIONS_INTERFACE does not reference any database object

PO.PO_LINE_LOCATIONS_INTERFACE is referenced by following:

SchemaPO
ViewPO_LINE_LOCATIONS_INTERFACE#