[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_LINE_LOCATIONS_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| 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
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PO_LINE_LOCATIONS_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INTERFACE_LINE_LOCATION_ID
|
| PO_LINE_LOCATIONS_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INTERFACE_HEADER_ID
|
| PO_LINE_LOCATIONS_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INTERFACE_LINE_ID
|
| PO_LINE_LOCATIONS_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROCESSING_ID
|
| PO_LINE_LOCATIONS_INTERFACE_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LINE_LOCATION_ID
|
| 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 |
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
FROM PO.PO_LINE_LOCATIONS_INTERFACE;
PO.PO_LINE_LOCATIONS_INTERFACE does not reference any database object
PO.PO_LINE_LOCATIONS_INTERFACE is referenced by following:
APPS
PO_LINE_LOCATIONS_INTERFACE
|
|
|
|