APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on MTL_SYSTEM_ITEMS_KFV
Line 1846: FROM EGO_ITM_USR_ATTR_INTRFC INTF, MTL_SYSTEM_ITEMS_KFV MSIK
1842: SET PROCESS_STATUS = G_PS_VAR_VSET_CHG_NOT_ALLOWED
1843: WHERE DATA_SET_ID = p_data_set_id
1844: AND PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
1845: AND ROW_IDENTIFIER IN (SELECT ROW_IDENTIFIER 1846: FROM EGO_ITM_USR_ATTR_INTRFC INTF, MTL_SYSTEM_ITEMS_KFV MSIK 1847: WHERE INTF.DATA_SET_ID = p_data_set_id
1848: AND INTF.PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
1849: AND MSIK.STYLE_ITEM_ID = INTF.INVENTORY_ITEM_ID
1850: AND MSIK.ORGANIZATION_ID = INTF.ORGANIZATION_ID