APPS.AHL_ENIGMA_UTIL_PKG dependencies on AHL_MC_HEADERS_B

Line 52: FROM ahl_mc_headers_b hdr,

48:
49: CURSOR get_model_and_ata_csr(c_relationship_id NUMBER) IS
50: SELECT model_code,
51: ata_code
52: FROM ahl_mc_headers_b hdr,
53: ahl_mc_relationships rel
54: WHERE rel.relationship_id = c_relationship_id
55: AND rel.mc_header_id = hdr.mc_header_id;
56:

Line 59: FROM ahl_unit_config_headers uc,ahl_mc_headers_b mc

55: AND rel.mc_header_id = hdr.mc_header_id;
56:
57: CURSOR get_model_and_tail_csr(c_uc_header_id NUMBER) IS
58: SELECT uc.name,model_code
59: FROM ahl_unit_config_headers uc,ahl_mc_headers_b mc
60: WHERE uc.master_config_id = mc.mc_header_id
61: AND unit_config_header_id = c_uc_header_id;
62:
63: CURSOR get_user_and_lang IS

Line 81: ahl_mc_headers_b MCH

77: FROM ahl_workorders AWO,
78: ahl_visits_b VST,
79: ahl_visit_tasks_b TSK,
80: ahl_unit_config_headers UCH,
81: ahl_mc_headers_b MCH
82: WHERE AWO.VISIT_TASK_ID=TSK.VISIT_TASK_ID
83: AND VST.VISIT_ID = TSK.VISIT_ID
84: AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(NVL(TSK.INSTANCE_ID,VST.ITEM_INSTANCE_ID)) = UCH.unit_config_header_id
85: AND MCH.mc_header_id = UCH.master_config_id