DBA Data[Home] [Help]

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 1018: FROM MTL_SYSTEM_ITEMS_B_KFV

1014: IF p_validate_only = FND_API.G_FALSE THEN
1015: UPDATE EGO_ITM_USR_ATTR_INTRFC intrfc
1016: SET INVENTORY_ITEM_ID =
1017: (SELECT INVENTORY_ITEM_ID
1018: FROM MTL_SYSTEM_ITEMS_B_KFV
1019: WHERE CONCATENATED_SEGMENTS = intrfc.ITEM_NUMBER
1020: AND ORGANIZATION_ID = intrfc.ORGANIZATION_ID)
1021: WHERE DATA_SET_ID = p_data_set_id
1022: AND PROCESS_STATUS = G_PS_IN_PROCESS

Line 1031: FROM MTL_SYSTEM_ITEMS_B_KFV

1027: /*
1028: UPDATE EGO_ITM_USR_ATTR_INTRFC intrfc
1029: SET INVENTORY_ITEM_ID =
1030: NVL( (SELECT INVENTORY_ITEM_ID
1031: FROM MTL_SYSTEM_ITEMS_B_KFV
1032: WHERE CONCATENATED_SEGMENTS = intrfc.ITEM_NUMBER
1033: AND ORGANIZATION_ID = intrfc.ORGANIZATION_ID
1034: ),
1035: (SELECT INVENTORY_ITEM_ID