Oracle Fusion · Data dictionary
POR_REQUISITION_LINES_ALL
SharedUsed in 20 subject areas68 reporting columns
Self-Service Procurement (POR), line table, one row per line item under the header.
Likely primary key: REQUISITION_HEADER_ID, LINE_NUMBER (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): AUCTION_HEADER_ID → PON_AUCTION_HEADERS_ALL · REQUISITION_HEADER_ID → POR_REQUISITION_HEADERS_ALL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTION_REQUIRED_CODE | ● | Code identifying the action required. | |
| AMOUNT | ● | Amount. | |
| ASSESSABLE_VALUE | ● | Assessable value. | |
| AT_SOURCING_FLAG | ● | Indicator (Y/N) for the at sourcing. | |
| AUCTION_HEADER_ID | ● | Identifier for the auction header. | |
| BACK_TO_BACK_FLAG | ● | Indicator (Y/N) for the back to back. | |
| BUYER_PROCESSING_FLAG | ● | Indicator (Y/N) for the buyer processing. | |
| CANCEL_DATE | ● | Cancel date. | |
| CANCEL_FLAG | ● | Indicator (Y/N) for the cancel. | |
| CANCEL_REASON | ● | Cancel reason. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURRENCY_AMOUNT | ● | Currency amount. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| CURRENCY_UNIT_PRICE | ● | Currency unit price. | |
| DAYS_EARLY_RECEIPT_ALLOWED | ● | Days early receipt allowed. | |
| DAYS_LATE_RECEIPT_ALLOWED | ● | Days late receipt allowed. | |
| DEFAULT_TAXATION_COUNTRY | ● | Default taxation country. | |
| DELIVER_TO_CUST_LOCATION_ID | ● | Identifier for the deliver to customer location. | |
| DESTINATION_TYPE_CODE | ● | Code identifying the destination type. | |
| FUNDS_STATUS | ● | Status of the funds. | |
| ITEM_DESCRIPTION | ● | Description of the item. | |
| ITEM_ID | ● | Identifier for the item. | |
| ITEM_REVISION | ● | Item revision. | |
| ITEM_SOURCE | ● | Item source. | |
| LAST_APPROVAL_DATE | ● | Last approval date. | |
| LAST_SUBMITTED_DATE | ● | Last submitted date. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LIFECYCLE_STATUS | ● | Status of the lifecycle. | |
| LINE_NUMBER | PK? | ● | Line number. |
| LINE_STATUS | ● | Status of the line. | |
| MANUFACTURER_NAME | ● | Name of the manufacturer. | |
| MANUFACTURER_PART_NUMBER | ● | Manufacturer part number. | |
| MATCHING_BASIS | ● | Matching basis. | |
| MODE_OF_TRANSPORT | ● | Mode of transport. | |
| MODIFIED_BY_BUYER_FLAG | ● | Indicator (Y/N) for the modified by buyer. | |
| NEED_BY_DATE | ● | Need by date. | |
| NOTE_TO_BUYER | ● | Note to buyer. | |
| NOTE_TO_SUPPLIER | ● | Note to supplier. | |
| ONE_TIME_LOCATION_FLAG | ● | Indicator (Y/N) for the one time location. | |
| ON_RFQ_FLAG | ● | Indicator (Y/N) for the on rfq. | |
| PARENT_REQ_LINE_ID | ● | Identifier for the parent req line. | |
| PO_LINE_ID | ● | Identifier for the purchase order line. | |
| PURCHASE_BASIS | ● | Purchase basis. | |
| QTY_RCV_TOLERANCE | ● | Quantity receiving tolerance. | |
| QUANTITY | ● | Quantity. | |
| RATE | ● | Rate. | |
| REQS_IN_POOL_FLAG | ● | Indicator (Y/N) for the reqs in pool. | |
| REQTOPO_AUTO_FAILED_REASON | ● | Reqtopo auto failed reason. | |
| REQUISITION_HEADER_ID | PK? | ● | Identifier for the requisition header. |
| REQUISITION_LINE_ID | ● | Identifier for the requisition line. | |
| RETURN_REASON | ● | Return reason. | |
| SALES_ORDER_NUMBER | ● | Sales order number. | |
| SECONDARY_QUANTITY | ● | Secondary quantity. | |
| SECONDARY_UOM_CODE | ● | Code identifying the secondary unit of measure. | |
| SERVICE_LEVEL | ● | Service level. | |
| SHIP_TO_CUST_LOCATION_ID | ● | Identifier for the shipment to customer location. | |
| SMART_FORM_ID | ● | Identifier for the smart form. | |
| SOURCE_DOCUMENT_TYPE | ● | Type of source document. | |
| SOURCE_TYPE_CODE | ● | Code identifying the source type. | |
| SUGGESTED_SUPPLIER_ITEM_NUMBER | ● | Suggested supplier item number. | |
| SUGGESTED_VENDOR_CONTACT | ● | Suggested vendor contact. | |
| SUGGESTED_VENDOR_NAME | ● | Name of the suggested vendor. | |
| SUGGESTED_VENDOR_SITE | ● | Suggested vendor site. | |
| TAX_CLASSIFICATION_CODE | ● | Code identifying the tax classification. | |
| UNIT_PRICE | ● | Unit price. | |
| UOM_CODE | ● | Code identifying the unit of measure. | |
| URGENT_FLAG | ● | Indicator (Y/N) for the urgent. | |
| VENDOR_ID | ● | Identifier for the vendor. |
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 - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Costing - Standard Cost Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Manufacturing - Actual Production Real Time
- Manufacturing - Material Usage Real Time
- Manufacturing - Production Exceptions Real Time
- Manufacturing - Purchased Item Usage Real Time
- Manufacturing - Work Order Performance Real Time
- Procurement - Pending Change Orders Real Time
- Procurement - Procure To Pay Real Time
- Procurement - Purchasing Agreements Real Time
- Procurement - Purchasing Real Time
- Procurement - Requisitions Real Time
- Procurement - Spend Real Time
- Sourcing - Supplier Awards Real Time
- Sourcing - Supplier Negotiations Real Time
- Sourcing - Supplier Responses Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for POR_REQUISITION_LINES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table