APPS.AHL_LTP_MATRL_AVAL_PVT SQL Statements

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

Line: 65

    SELECT meaning
    FROM mfg_lookups
    WHERE lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
     AND lookup_code = c_error_code;

Line: 71

    SELECT instance_id
    FROM  MRP_AP_APPS_INSTANCES;

Line: 120

   SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
          INTO l_session_id FROM DUAL;

Line: 179

   l_atp_table.Insert_Flag             := Mrp_Atp_Pub.number_arr(NULL);

Line: 428

   SELECT 1 FROM ahl_visits_b
   WHERE visit_id = c_visit_id
   AND (organization_id IS NULL
   OR department_id IS NULL
      OR  start_date_time IS NULL);

Line: 436

   SELECT scheduled_material_id,uom,status,
          organization_id,visit_task_id
   FROM ahl_schedule_materials
   WHERE scheduled_material_id = C_SCH_MAT_ID;

Line: 442

   SELECT CONCATENATED_SEGMENTS
   FROM mtl_system_items_kfv
   WHERE inventory_item_id = c_item_id
   AND organization_id = c_org_id;

Line: 699

   SELECT schedule_material_id,
          object_version_number,
          visit_id,
          visit_task_id,
          visit_task_name,
          inventory_item_id,
          item_number,  --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
          requested_quantity,
          requested_date,
          scheduled_date,
          scheduled_quantity,
          uom,
          sales_order_line_id,
          task_status_code,
          meaning
   FROM ahl_visit_task_matrl_v, FND_LOOKUP_VALUES_VL
   WHERE visit_id = C_VISIT_ID
    AND (requested_quantity <> 0)
    AND NVL(mat_status,'X') <> 'IN-SERVICE' --Added by sowsubra
    AND LOOKUP_TYPE(+) = 'AHL_VWP_TASK_STATUS'
    AND LOOKUP_code = task_status_code;

Line: 878

    p_atp_table.Insert_Flag.Extend;

Line: 931

   SELECT meaning
     FROM mfg_lookups
    WHERE lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
  AND lookup_code = C_Error_Code;

Line: 941

    select  DECODE( SIGN( trunc(scheduled_date) - trunc(requested_date)),1,scheduled_date,null) scheduled_date,
            scheduled_quantity
    from    ahl_schedule_materials asmt,
            AHL_VISIT_TASKS_B tsk
    where   TSK.VISIT_ID = ASMT.VISIT_ID
    AND     TSK.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
    AND     NVL(ASMT.STATUS,' ') <> 'DELETED'
    AND     NVL(TSK.STATUS_CODE,'X') <> 'DELETED'
    AND     scheduled_material_id = c_sch_mat_id;

Line: 951

    SELECT scheduled_date ,
           status, --Added by sowsubra
           scheduled_quantity
    FROM ahl_schedule_materials asmt,
         AHL_VISIT_TASKS_B tsk
    WHERE TSK.VISIT_ID = ASMT.VISIT_ID
     AND TSK.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
     AND NVL(ASMT.STATUS,' ') <> 'DELETED'
     AND NVL(TSK.STATUS_CODE,'X') <> 'DELETED'
     AND scheduled_material_id = c_sch_mat_id
     AND scheduled_date is not null
     AND scheduled_date >= requested_date;

Line: 966

    SELECT visit_number||visit_task_number Order_Number
    FROM ahl_visit_tasks_v
    WHERE visit_task_id = c_visit_task_id;

Line: 971

   SELECT instance_id
   FROM  MRP_AP_APPS_INSTANCES;

Line: 1024

   SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
          INTO l_session_id FROM DUAL;

Line: 1222

            UPDATE ahl_schedule_materials
            SET scheduled_date = x_atp_table.ship_date(i),
                scheduled_quantity = l_planned_matrl_tbl(i).required_quantity,
                object_version_number = object_version_number + 1
            WHERE scheduled_material_id = x_atp_table.identifier(i);

Line: 1339

  SELECT schm.inventory_item_id,
         schm.organization_id,
         schm.uom,
         schm.requested_date,
         schm.status mat_status, --Added by sowsubra
         avtm.item_number --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
  FROM ahl_schedule_materials schm,
       ahl_visit_task_matrl_v avtm
  WHERE schm.scheduled_material_id = avtm.schedule_material_id
   AND avtm.schedule_material_id = c_sch_mat_id;

Line: 1352

 SELECT visit_id,
        visit_task_id,
        visit_task_name,
        requested_quantity,
        scheduled_date,
        scheduled_quantity,
        item_number, --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
        object_version_number,
        inventory_item_id,
        uom,
        requested_date,
        task_status_code,
        meaning
 FROM ahl_visit_task_matrl_v,FND_LOOKUP_VALUES_VL
 WHERE schedule_material_id = c_sch_mat_id
  AND LOOKUP_TYPE(+) = 'AHL_VWP_TASK_STATUS'
  AND   LOOKUP_code = task_status_code;

Line: 1612

 SELECT schm.scheduled_material_id,
        schm.organization_id,
        schm.visit_id,
        schm.visit_task_id,
        schm.material_request_type,
        schm.uom,
        schm.inventory_item_id,
        schm.requested_date,
        schm.requested_quantity,
        mtl.concatenated_segments
 FROM ahl_schedule_materials schm,
      mtl_system_items_vl mtl
 WHERE schm.inventory_item_id = mtl.inventory_item_id
  AND schm.organization_id = mtl.organization_id
  AND schm.requested_quantity <> 0
  AND NVL(schm.status, 'X') <> 'IN-SERVICE' --Added by sowsubra for Issue 105
  AND schm.visit_id = C_VISIT_ID;