Oracle Fusion · Data dictionary
RCV_SHIPMENT_LINES
ProcurementUsed in 39 subject areas42 reporting columns
Receiving (RCV), line table, one row per line item under the header.
Likely primary key: SHIPMENT_HEADER_ID, LINE_NUM (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): SHIPMENT_HEADER_ID → RCV_SHIPMENT_HEADERS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AMOUNT_RECEIVED | ● | Amount received. | |
| ASN_LINE_FLAG | ● | Indicator (Y/N) for the advance shipment notice line. | |
| BAR_CODE_LABEL | ● | Bar code label. | |
| COMMENTS | ● | Comments. | |
| CONSIGNED_FLAG | ● | Indicator (Y/N) for the consigned. | |
| CONSUMED_QUANTITY | ● | Consumed quantity. | |
| CONTAINER_NUM | ● | Container number. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DESTINATION_TYPE_CODE | ● | Code identifying the destination type. | |
| ITEM_DESCRIPTION | ● | Description of the item. | |
| ITEM_ID | ● | Identifier for the item. | |
| ITEM_REVISION | ● | Item revision. | |
| 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_NUM | PK? | ● | Line number. |
| PACKING_SLIP | ● | Packing slip. | |
| PO_DISTRIBUTION_ID | ● | Identifier for the purchase order distribution. | |
| PO_HEADER_ID | ● | Identifier for the purchase order header. | |
| PO_LINE_ID | ● | Identifier for the purchase order line. | |
| PO_LINE_LOCATION_ID | ● | Identifier for the purchase order line location. | |
| QUANTITY_ACCEPTED | ● | Quantity accepted. | |
| QUANTITY_DELIVERED | ● | Quantity delivered. | |
| QUANTITY_RECEIVED | ● | Quantity received. | |
| QUANTITY_REJECTED | ● | Quantity rejected. | |
| QUANTITY_RETURNED | ● | Quantity returned. | |
| QUANTITY_SHIPPED | ● | Quantity shipped. | |
| RA_EXPECTED_RECEIPT_DATE | ● | Ra expected receipt date. | |
| ROUTING_HEADER_ID | ● | Identifier for the routing header. | |
| SECONDARY_QTY_ACCEPTED | ● | Secondary quantity accepted. | |
| SECONDARY_QTY_DELIVERED | ● | Secondary quantity delivered. | |
| SECONDARY_QTY_REJECTED | ● | Secondary quantity rejected. | |
| SECONDARY_QTY_RETURNED | ● | Secondary quantity returned. | |
| SECONDARY_QUANTITY_RECEIVED | ● | Secondary quantity received. | |
| SECONDARY_QUANTITY_SHIPPED | ● | Secondary quantity shipped. | |
| SECONDARY_UOM_CODE | ● | Code identifying the secondary unit of measure. | |
| SHIPMENT_HEADER_ID | PK? | ● | Identifier for the shipment header. |
| SHIPMENT_LINE_ID | ● | Identifier for the shipment line. | |
| SHIPMENT_LINE_STATUS_CODE | ● | Code identifying the shipment line status. | |
| SOURCE_DOCUMENT_CODE | ● | Code identifying the source document. | |
| TRUCK_NUM | ● | Truck number. | |
| UOM_CODE | ● | Code identifying the unit of measure. |
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 - Receipt Accounting 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 Transfer Order 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
- 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
- Payables Invoices - Holds Real Time
Need the extract + dbt staging for RCV_SHIPMENT_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table