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 |