DBA Data[Home] [Help]

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1052: FROM MTL_SYSTEM_ITEMS_KFV MSIK

1048: */
1049:
1050: UPDATE EGO_ITM_USR_ATTR_INTRFC INTRFC
1051: SET INVENTORY_ITEM_ID = NVL((SELECT INVENTORY_ITEM_ID
1052: FROM MTL_SYSTEM_ITEMS_KFV MSIK
1053: WHERE MSIK.CONCATENATED_SEGMENTS = INTRFC.ITEM_NUMBER
1054: AND MSIK.ORGANIZATION_ID = INTRFC.ORGANIZATION_ID
1055: ),
1056: NVL((SELECT INVENTORY_ITEM_ID

Line 2280: FROM EGO_ITM_USR_ATTR_INTRFC INTF, MTL_SYSTEM_ITEMS_KFV MSIK

2276: SET PROCESS_STATUS = G_PS_VAR_VSET_CHG_NOT_ALLOWED
2277: WHERE DATA_SET_ID = p_data_set_id
2278: AND PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
2279: AND ROW_IDENTIFIER IN (SELECT ROW_IDENTIFIER
2280: FROM EGO_ITM_USR_ATTR_INTRFC INTF, MTL_SYSTEM_ITEMS_KFV MSIK
2281: WHERE INTF.DATA_SET_ID = p_data_set_id
2282: AND INTF.PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
2283: AND MSIK.STYLE_ITEM_ID = INTF.INVENTORY_ITEM_ID
2284: AND MSIK.ORGANIZATION_ID = INTF.ORGANIZATION_ID