Oracle Fusion · Data dictionary
PO_LINE_LOCATIONS_ALL
ProcurementUsed in 46 subject areas85 reporting columns
Purchasing (PO), transaction table (rows scoped across all operating units).
Likely primary key: LINE_LOCATION_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCRUE_ON_RECEIPT_FLAG | ● | Indicator (Y/N) for the accrue on receipt. | |
| ALLOW_SUBSTITUTE_RECEIPTS_FLAG | ● | Indicator (Y/N) for the allow substitute receipts. | |
| AMOUNT | ● | Amount. | |
| AMOUNT_ACCEPTED | ● | Amount accepted. | |
| AMOUNT_BILLED | ● | Amount billed. | |
| AMOUNT_CANCELLED | ● | Amount cancelled. | |
| AMOUNT_RECEIVED | ● | Amount received. | |
| AUTO_CLOSURE_MODE | ● | Auto closure mode. | |
| BACK_TO_BACK_FLAG | ● | Indicator (Y/N) for the back to back. | |
| CANCEL_DATE | ● | Cancel date. | |
| CLOSED_FOR_INVOICE_DATE | ● | Closed for invoice date. | |
| CLOSED_FOR_RECEIVING_DATE | ● | Closed for receiving date. | |
| CLOSED_REASON | ● | Closed reason. | |
| COUNTRY_OF_ORIGIN_CODE | ● | Code identifying the country of origin. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DAYS_EARLY_RECEIPT_ALLOWED | ● | Days early receipt allowed. | |
| DAYS_LATE_RECEIPT_ALLOWED | ● | Days late receipt allowed. | |
| DESCRIPTION | ● | Description. | |
| DESTINATION_TYPE_CODE | ● | Code identifying the destination type. | |
| END_DATE | ● | End date. | |
| ENFORCE_SHIP_TO_LOCATION_CODE | ● | Code identifying the enforce shipment to location. | |
| FUNDS_STATUS | ● | Status of the funds. | |
| INPUT_TAX_CLASSIFICATION_CODE | ● | Code identifying the input tax classification. | |
| INSPECTION_REQUIRED_FLAG | ● | Indicator (Y/N) for the inspection required. | |
| INVOICE_CLOSE_TOLERANCE | ● | Invoice close tolerance. | |
| LAST_ACCEPT_DATE | ● | Last accept date. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LINE_INTENDED_USE | ● | Line intended use. | |
| LINE_LOCATION_ID | PK? | ● | Identifier for the line location. |
| MATCH_OPTION | ● | Match option. | |
| MODE_OF_TRANSPORT | ● | Mode of transport. | |
| NEED_BY_DATE | ● | Need by date. | |
| NOTE_TO_RECEIVER | ● | Note to receiver. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PAYMENT_TYPE | ● | Type of payment. | |
| PO_HEADER_ID | ● | Identifier for the purchase order header. | |
| PO_LINE_ID | ● | Identifier for the purchase order line. | |
| PRICE_DISCOUNT | ● | Price discount. | |
| PRICE_OVERRIDE | ● | Price override. | |
| PRODUCT_CATEGORY | ● | Product category. | |
| PRODUCT_FISC_CLASSIFICATION | ● | Product fisc classification. | |
| PRODUCT_TYPE | ● | Type of product. | |
| PROMISED_DATE | ● | Promised date. | |
| PROMISED_SHIP_DATE | ● | Promised shipment date. | |
| QTY_RCV_EXCEPTION_CODE | ● | Code identifying the quantity receiving exception. | |
| QTY_RCV_TOLERANCE | ● | Quantity receiving tolerance. | |
| QUANTITY | ● | Quantity. | |
| QUANTITY_ACCEPTED | ● | Quantity accepted. | |
| QUANTITY_BILLED | ● | Quantity billed. | |
| QUANTITY_CANCELLED | ● | Quantity cancelled. | |
| QUANTITY_RECEIVED | ● | Quantity received. | |
| QUANTITY_SHIPPED | ● | Quantity shipped. | |
| RECEIPT_DAYS_EXCEPTION_CODE | ● | Code identifying the receipt days exception. | |
| RECEIPT_REQUIRED_FLAG | ● | Indicator (Y/N) for the receipt required. | |
| RECEIVE_CLOSE_TOLERANCE | ● | Receive close tolerance. | |
| RECEIVING_ROUTING_ID | ● | Identifier for the receiving routing. | |
| REQUESTED_SHIP_DATE | ● | Requested shipment date. | |
| RETAINAGE_RATE | ● | Retainage rate. | |
| RETAINAGE_RELEASED_AMOUNT | ● | Retainage released amount. | |
| RETAINAGE_WITHHELD_AMOUNT | ● | Retainage withheld amount. | |
| SALES_ORDER_NUMBER | ● | Sales order number. | |
| SCHEDULE_STATUS | ● | Status of the schedule. | |
| SECONDARY_QUANTITY | ● | Secondary quantity. | |
| SECONDARY_QUANTITY_CANCELLED | ● | Secondary quantity cancelled. | |
| SECONDARY_UOM_CODE | ● | Code identifying the secondary unit of measure. | |
| SERVICE_LEVEL | ● | Service level. | |
| SFO_AGREEMENT_NUMBER | ● | Sfo agreement number. | |
| SHIPMENT_CLOSED_DATE | ● | Shipment closed date. | |
| SHIPMENT_NUM | ● | Shipment number. | |
| SHIPMENT_TYPE | ● | Type of shipment. | |
| SHIPPING_UOM_CODE | ● | Code identifying the shipping unit of measure. | |
| SHIPPING_UOM_QUANTITY | ● | Shipping unit of measure quantity. | |
| SHIPPING_UOM_QUANTITY_ACCEPTED | ● | Shipping unit of measure quantity accepted. | |
| SHIPPING_UOM_QUANTITY_CANCELED | ● | Shipping unit of measure quantity canceled. | |
| SHIPPING_UOM_QUANTITY_RECEIVED | ● | Shipping unit of measure quantity received. | |
| SHIPPING_UOM_QUANTITY_SHIPPED | ● | Shipping unit of measure quantity shipped. | |
| SHIP_TO_CUST_ID | ● | Identifier for the shipment to customer. | |
| SHIP_TO_CUST_LOCATION_ID | ● | Identifier for the shipment to customer location. | |
| SHIP_TO_LOCATION_ID | ● | Identifier for the shipment to location. | |
| START_DATE | ● | Start date. | |
| SUPPLIER_ORDER_LINE_NUMBER | ● | Supplier order line number. | |
| TRX_BUSINESS_CATEGORY | ● | Transaction business category. | |
| UOM_CODE | ● | Code identifying the unit of measure. | |
| USER_DEFINED_FISC_CLASS | ● | User defined fisc class. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Budgetary Control - Transactions Real Time
- Costing - Cost Accounting Real Time
- Costing - Cost Rollup Details Real Time
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Costing - Standard Cost Real Time
- Costing - Where Used Details Real Time
- Costing - Work Order Costs Real Time
- Enterprise Quality Actions Real Time
- Enterprise Quality Issues Real Time
- Fiscal Document Capture Transactions Real Time
- Fiscal Document Holds Real Time
- Fiscal Document Item Deliveries Real Time
- Inventory - Inventory Supply Real Time
- Inventory - Inventory Transfer Order Real Time
- Inventory - Kanban Activity Real Time
- Maintenance Management - Maintenance Exception Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Maintenance Management - Work Order Performance Real Time
Need the extract + dbt staging for PO_LINE_LOCATIONS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table