INV_DO_CHECK_GT
INV_DO_CHECK_GT is used by Quantity Tree to check if the lock is taken by another tree for updation of quantities.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
Columns
Name |
---|
ROOT_IDNUMBERTree Id of Quantity Tree ORGANIZATION_IDNUMBEROrganization Id of tree INVENTORY_ITEM_IDNUMBERItem Id of tree LOT_CONTROLNUMBERFlag if item is lot controlled or not LINE_IDNUMBERDemand source line id of tree |
Indexes
Index | Uniqueness | Columns |
---|---|---|
INV_DO_CHECK_GT_N1 | Non Unique | ORGANIZATION_ID, INVENTORY_ITEM_ID |