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