APPS.AHL_ENIGMA_UTIL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 50

         SELECT   model_code,
                  ata_code
         FROM     ahl_mc_headers_b hdr,
                  ahl_mc_relationships rel
         WHERE    rel.relationship_id = c_relationship_id
         AND      rel.mc_header_id = hdr.mc_header_id;

Line: 58

         SELECT   uc.name,model_code
         FROM     ahl_unit_config_headers uc,ahl_mc_headers_b mc
         WHERE    uc.master_config_id = mc.mc_header_id
         AND      unit_config_header_id = c_uc_header_id;

Line: 64

         SELECT   FND_GLOBAL.USER_NAME,
                  userenv('LANG')
         FROM     dual;

Line: 69

         SELECT   enigma_doc_id
         FROM     ahl_workorders wo,ahl_routes_b rt
         WHERE    wo.workorder_id = c_workorder_id
         AND      wo.route_id  = rt.route_id;

Line: 76

         SELECT  model_code, UCH.name, NVL(TSK.INSTANCE_ID,VST.ITEM_INSTANCE_ID)
         FROM    ahl_workorders AWO,
                 ahl_visits_b VST,
                 ahl_visit_tasks_b TSK,
                 ahl_unit_config_headers UCH,
                 ahl_mc_headers_b MCH
         WHERE   AWO.VISIT_TASK_ID=TSK.VISIT_TASK_ID
         AND     VST.VISIT_ID = TSK.VISIT_ID
         AND     AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(NVL(TSK.INSTANCE_ID,VST.ITEM_INSTANCE_ID)) =  UCH.unit_config_header_id
         AND     MCH.mc_header_id = UCH.master_config_id
         AND     workorder_id = c_workorder;

Line: 90

         SELECT   enigma_doc_id,model_code
         FROM     ahl_routes_b
         WHERE    route_id = c_route_id;

Line: 288

      SELECT   enigma_doc_id
      INTO     l_doc_id
      FROM     ahl_routes_b RT,ahl_workorders WO
      WHERE    WO.workorder_id = p_workorder_id
      AND      WO.route_id = RT.route_id;

Line: 304

   SELECT trim(fnd_profile.value('AHL_ENIGMA_AMM_DOC_AVLBL')) INTO l_amm_doc_avail FROM dual;