DBA Data[Home] [Help]

APPS.EAM_ASSET_ATTR_IMPORT_PVT dependencies on MTL_EAM_ASSET_NUM_INTERFACE

Line 124: FROM MTL_EAM_ASSET_NUM_INTERFACE meani

120: -- Cursor for the Asset Number in this processing group and Header
121:
122: CURSOR asset_numbers_cur IS
123: SELECT instance_number
124: FROM MTL_EAM_ASSET_NUM_INTERFACE meani
125: WHERE meani.interface_header_id = p_interface_header_id
126: ;
127:
128: -- Cursor for all attribute Group in this processing group

Line 297: MTL_EAM_ASSET_NUM_INTERFACE meani

293: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
294: SET (meavi.association_id) =
295: (SELECT meaag.association_id
296: FROM MTL_EAM_ASSET_ATTR_GROUPS meaag,
297: MTL_EAM_ASSET_NUM_INTERFACE meani
298: WHERE meani.inventory_item_id = meaag.inventory_item_id
299: AND meani.interface_header_id = meavi.interface_header_id
300: AND meavi.application_id = meaag.application_id
301: AND meavi.descriptive_flexfield_name = meaag.descriptive_flexfield_name