DBA Data[Home] [Help]

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 860: FROM MTL_SYSTEM_ITEMS_B_KFV

856: IF p_validate_only = FND_API.G_FALSE THEN
857: UPDATE EGO_ITM_USR_ATTR_INTRFC intrfc
858: SET INVENTORY_ITEM_ID =
859: (SELECT INVENTORY_ITEM_ID
860: FROM MTL_SYSTEM_ITEMS_B_KFV
861: WHERE CONCATENATED_SEGMENTS = intrfc.ITEM_NUMBER
862: AND ORGANIZATION_ID = intrfc.ORGANIZATION_ID)
863: WHERE DATA_SET_ID = p_data_set_id
864: AND PROCESS_STATUS = G_PS_IN_PROCESS

Line 871: FROM MTL_SYSTEM_ITEMS_B_KFV

867: ELSE
868: UPDATE EGO_ITM_USR_ATTR_INTRFC intrfc
869: SET INVENTORY_ITEM_ID =
870: NVL( (SELECT INVENTORY_ITEM_ID
871: FROM MTL_SYSTEM_ITEMS_B_KFV
872: WHERE CONCATENATED_SEGMENTS = intrfc.ITEM_NUMBER
873: AND ORGANIZATION_ID = intrfc.ORGANIZATION_ID
874: ),
875: (SELECT INVENTORY_ITEM_ID