APPS.MTL_SYSTEM_ITEMS_T2 dependencies on WIP_CONSTANTS

Line 87: AND ENTITY_TYPE = WIP_CONSTANTS.REPETITIVE;

83: UPDATE WIP_ENTITIES
84: SET DESCRIPTION = :new.DESCRIPTION
85: WHERE ORGANIZATION_ID = :new.organization_id
86: AND PRIMARY_ITEM_ID = :new.inventory_item_id
87: AND ENTITY_TYPE = WIP_CONSTANTS.REPETITIVE;
88: END IF;
89:
90: old_segmt(1) :=:old.SEGMENT1;
91: old_segmt(2) :=:old.SEGMENT2;

Line 184: AND entity_type = WIP_CONSTANTS.REPETITIVE

180: IF old_item_name <> new_item_name THEN
181: UPDATE wip_entities
182: SET WIP_ENTITY_NAME = new_item_name
183: WHERE PRIMARY_ITEM_ID = :new.INVENTORY_ITEM_ID
184: AND entity_type = WIP_CONSTANTS.REPETITIVE
185: AND organization_id = :new.organization_id
186: AND wip_entity_name = old_item_name;
187: END IF;
188: