DBA Data[Home] [Help]

APPS.EAM_ASSET_LOG_PUB dependencies on MTL_PARAMETERS

Line 59: FROM csi_item_instances cii, mtl_parameters mp

55: WHERE equipment_gen_object_id = nvl(p_equipment_gen_object_id, equipment_gen_object_id) ;
56:
57: CURSOR corgid IS
58: SELECT mp.maint_organization_id
59: FROM csi_item_instances cii, mtl_parameters mp
60: WHERE cii.equipment_gen_object_id = nvl(p_equipment_gen_object_id, cii.equipment_gen_object_id) AND
61: p_event_date BETWEEN active_start_date AND
62: NVL(active_end_date, SYSDATE) AND
63: cii.last_vld_organization_id = mp.organization_id;