INV_RSV_GT
This is a global temp table that is used to capture reservation related data for a session.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Comments |
|---|---|---|---|
| P_ORGANIZATION_ID | NUMBER | Unique ID used to identify an organization. | |
| P_INVENTORY_ITEM_ID | NUMBER | Unique ID used to identify an item. | |
| P_PRIMARY_RESERVATION_QUANTITY | NUMBER | Reservation Quantity in the primary unit of measure of the item being reserved. | |
| P_TREE_ID | NUMBER | Unique ID used to identify an instance of the quantity tree. | |
| P_RESERVATION_ID | NUMBER | Unique ID used to identify a reservation record. | |
| P_DEMAND_SOURCE_LINE_ID | NUMBER | Unique ID used to identify the demand document line. | |
| P_DEMAND_SOURCE_HEADER_ID | NUMBER | Unique ID used to identify the demand document. | |
| P_DEMAND_SOURCE_NAME | VARCHAR2 | 1000 | Name used to identify the user-defined demand document. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| INV_RSV_GT_N1 | Non Unique | P_TREE_ID, P_RESERVATION_ID |