INV_SUPPLY
INV_SUPPLY stores incoming supply information for an organization. This table forms one of the sources in Inventory's Demand-Supply form. There are four different types of supply captured in this table: . 1) Approved Requisitions . 2) Approved Purchase orders . 3) Shipments from suppliers . 4) Intransit shipments from another organization . Types 3 and 4 could be distinguished by the presence of data in the INTRANSIT_OWNING_ORGANIZATION_ID column, which identifies the ownership of the items in intransit. If this column is null then it means that the shipment supply is from a Vendor. . This information is used by the available to promise routine to derive the ATP information as appropiate. Quantities of items in intransit are also kept track of in the table. . Records in INV_SUPPLY are created every time you approve a requisition or a PO or create an intransit shipment. One record of REQ type will be created for one requisition line when the requisition is approved. One record of PO type will be created per PO distribution when a PO is approved and one record per shipment line will be created when a shipment is created. . Records in INV_SUPPLY will be recreated whenever there are transactions such as return to receiving, return to vendor or cancellation of purchase orders. . Records in INV_SUPPLY are deleted every time you change the document status to not approved. For example, a PO would require approval if you change the line and shipment quantity. If such a PO is re-approved then the PO supply will be recreated for the new quantity. . The supply type code of a REQ supply record is changed to PO every time a requisition is autocreated. Similarly the supply type code is changed from PO to RECEIVING when a PO is fully received. If a PO is partially received then a supply with the supply type code of RECEIVING will be created for the quantity received. When the receipt is delivered the RECEIVING supply is deleted. SHIPMENT supply works in the same way as PO supply. . There is a database trigger on INV_SUPPLY with the name INV_SUPPLY_T. This trigger fires on insert, update or deletion of records in INV_SUPPLY. It inserts records into MRP_RELIEF_INTERFACE table.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_SUPPLY_PK |
SUPPLY_TYPE_CODE, SUPPLY_SOURCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| SUPPLY_TYPE_CODE | VARCHAR2 | 25 | Yes | This code indicates the supply type. | ||
| SUPPLY_SOURCE_ID | NUMBER | 18 | Yes | Supply source unique identifier REQ_HEADER_ID, PO_DISTRIBUTION_ID, SHIPMENT_LINE_ID or RCV_TRANSACTION_ID depending on SUPPLY_TYPE_CODE | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| REQ_HEADER_ID | NUMBER | 18 | Identifies the requisition header. | |||
| REQ_LINE_ID | NUMBER | 18 | Identifies the requisition line. | |||
| PO_HEADER_ID | NUMBER | 18 | Purchase order header identifier | |||
| PO_LINE_ID | NUMBER | 18 | This identifies a purchase order line. | |||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order line location identifier | |||
| PO_DISTRIBUTION_ID | NUMBER | 18 | Purchase order distribution Identifier | |||
| SHIPMENT_HEADER_ID | NUMBER | 18 | This column identifies the shipment. | |||
| SHIPMENT_LINE_ID | NUMBER | 18 | This identifies the shipment line. | |||
| RCV_TRANSACTION_ID | NUMBER | 18 | Receiving transaction identifier | |||
| ITEM_ID | NUMBER | 18 | This identifies the inventory item. | |||
| ITEM_REVISION | VARCHAR2 | 18 | Revision of the inventory item. | |||
| CATEGORY_ID | NUMBER | 18 | This identifies the item category. | |||
| QUANTITY | NUMBER | Yes | This is the actual supply quantity. | |||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code for actual supply quantity | |||
| TO_ORG_PRIMARY_QUANTITY | NUMBER | Supply quantity in terms of primary unit of measure of item in destination organization | ||||
| TO_ORG_PRIMARY_UOM_CODE | VARCHAR2 | 3 | Primary unit of measure code of the item in destination organization | |||
| RECEIPT_DATE | DATE | Expected or actual receipt date depending on supply type | ||||
| NEED_BY_DATE | DATE | This is the original need by date. | ||||
| EXPECTED_DELIVERY_DATE | DATE | Expected delivery date (receipt Date + post-processing lead time for MFG) | ||||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Yes | Destination type (expense location, WIP jobs or inventory) | ||
| LOCATION_ID | NUMBER | 18 | Location identifier within receiving/inspection | |||
| FROM_ORGANIZATION_ID | NUMBER | 18 | Sending organization identifier for interorg shipment | |||
| FROM_SUBINVENTORY | VARCHAR2 | 10 | Sending subinventory for interorg shipment | |||
| TO_ORGANIZATION_ID | NUMBER | 18 | Destination organization identifier | |||
| TO_SUBINVENTORY | VARCHAR2 | 10 | Name of the destination subinventory. | |||
| INTRANSIT_OWNING_ORG_ID | NUMBER | 18 | Owner organization identifier for interorg shipment | |||
| MRP_PRIMARY_QUANTITY | NUMBER | MRP processed quantity in term of primary UOM of item in destination organization | ||||
| MRP_PRIMARY_UOM | VARCHAR2 | 25 | MRP processed primary UOM of item in destination organization | |||
| MRP_EXPECTED_DELIVERY_DATE | DATE | MRP's current expected delivery date | ||||
| MRP_DESTINATION_TYPE_CODE | VARCHAR2 | 25 | MRP's current destination type (Destination Type change between REQs and POs) | |||
| MRP_TO_ORGANIZATION_ID | NUMBER | 18 | MRP's current destination organization (destination org can be changed prior to receipt) | |||
| MRP_TO_SUBINVENTORY | VARCHAR2 | 10 | MRP's current destination subinventory (destination sub can be changed until a delivery is made) | |||
| CHANGE_FLAG | VARCHAR2 | 1 | Flag for marking records to be processed by Supply Update function | |||
| CHNAGE_TYPE | VARCHAR2 | 25 | This column indicates the CHNAGE type. | Obsolete | ||
| CHANGE_TYPE | VARCHAR2 | 25 | Change type to indicate changes to ignore for MRP | |||
| COST_GROUP_ID | NUMBER | 18 | Cost group id to which inventory belongs | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
| TRANSFER_ORDER_HEADER_ID | NUMBER | 18 | Transfer order header unique identifier | |||
| TRANSFER_ORDER_LINE_ID | NUMBER | 18 | Transfer order line unique identifier | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_SUPPLY | por_requisition_headers_all | REQ_HEADER_ID |
| INV_SUPPLY | rcv_transactions | RCV_TRANSACTION_ID |
| INV_SUPPLY | egp_item_org_associations | ITEM_ID, TO_ORGANIZATION_ID |
| INV_SUPPLY | egp_categories_b | CATEGORY_ID |
| INV_SUPPLY | inv_secondary_inventories | FROM_SUBINVENTORY, FROM_ORGANIZATION_ID |
| INV_SUPPLY | inv_org_parameters | TO_ORGANIZATION_ID |
| INV_SUPPLY | por_requisition_lines_all | REQ_LINE_ID |
| INV_SUPPLY | inv_secondary_inventories | TO_SUBINVENTORY, TO_ORGANIZATION_ID |
| INV_SUPPLY | inv_org_parameters | INTRANSIT_OWNING_ORG_ID |
| INV_SUPPLY | inv_org_parameters | MRP_TO_ORGANIZATION_ID |
| INV_SUPPLY | inv_secondary_inventories | MRP_TO_SUBINVENTORY, MRP_TO_ORGANIZATION_ID |
| INV_SUPPLY | po_headers_all | PO_HEADER_ID |
| INV_SUPPLY | po_lines_all | PO_LINE_ID |
| INV_SUPPLY | po_line_locations_all | PO_LINE_LOCATION_ID |
| INV_SUPPLY | po_distributions_all | PO_DISTRIBUTION_ID |
| INV_SUPPLY | rcv_shipment_headers | SHIPMENT_HEADER_ID |
| INV_SUPPLY | rcv_shipment_lines | SHIPMENT_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_SUPPLY_N10 | Non Unique | FUSION_TS_TX_DATA | CHANGE_FLAG |
| INV_SUPPLY_N11 | Non Unique | FUSION_TS_TX_DATA | ITEM_ID, TO_ORGANIZATION_ID, SUPPLY_TYPE_CODE, DESTINATION_TYPE_CODE |
| INV_SUPPLY_N12 | Non Unique | FUSION_TS_TX_DATA | MRP_TO_ORGANIZATION_ID, ITEM_ID, SUPPLY_TYPE_CODE, DESTINATION_TYPE_CODE |
| INV_SUPPLY_N13 | Non Unique | FUSION_TS_TX_DATA | FROM_ORGANIZATION_ID |
| INV_SUPPLY_N14 | Non Unique | FUSION_TS_TX_DATA | RCV_TRANSACTION_ID |
| INV_SUPPLY_N2 | Non Unique | FUSION_TS_TX_DATA | PO_DISTRIBUTION_ID |
| INV_SUPPLY_N3 | Non Unique | FUSION_TS_TX_DATA | PO_LINE_LOCATION_ID |
| INV_SUPPLY_N4 | Non Unique | FUSION_TS_TX_DATA | PO_LINE_ID |
| INV_SUPPLY_N5 | Non Unique | FUSION_TS_TX_DATA | PO_HEADER_ID |
| INV_SUPPLY_N7 | Non Unique | FUSION_TS_TX_DATA | REQ_HEADER_ID |
| INV_SUPPLY_N8 | Non Unique | FUSION_TS_TX_DATA | REQ_LINE_ID |
| INV_SUPPLY_N9 | Non Unique | FUSION_TS_TX_DATA | SHIPMENT_HEADER_ID |
| INV_SUPPLY_U1 | Unique | FUSION_TS_TX_DATA | SUPPLY_TYPE_CODE, SUPPLY_SOURCE_ID |