APPS.INVWATP SQL Statements

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

Line: 13

FUNCTION WebAtpInsert
(
  x_organization_id number,
  x_inventory_item_id number,
  x_atp_rule_id number,
  x_request_quantity number,
  x_request_primary_uom_quantity number,
  x_request_date date,
  x_atp_lead_time number,
  x_uom_code varchar2,
  x_demand_class varchar2,
  x_n_column2 number
)
return number
is
  rec_mgav  mtl_group_atps_view%rowtype;

Line: 38

    select
      mtl_demand_interface_s.nextval
    into
      rec_mgav.ATP_GROUP_ID
    from
      dual;

Line: 67

    select atp_rule_id
    into
      rec_mgav.atp_rule_id
    from
       mtl_system_items
    where
       inventory_item_id = x_inventory_item_id and
       organization_id = x_organization_id;

Line: 80

          SELECT r.rule_id
          INTO
            rec_mgav.atp_rule_id
          FROM
            mtl_parameters p, mtl_atp_rules r
          WHERE
            p.default_atp_rule_id = r.rule_id
            AND p.organization_id =  x_organization_id;

Line: 123

    select primary_uom_code
    into  rec_mgav.uom_code
    from mtl_system_items
    where
      inventory_item_id = x_inventory_item_id and
      organization_id   = x_organization_id;

Line: 153

    SELECT MTL.ORGANIZATION_ID
    into rec_mgav.atp_calendar_organization_id
    FROM   HR_ORGANIZATION_UNITS HR, MTL_PARAMETERS MTL
       WHERE  HR.ORGANIZATION_ID = MTL.ORGANIZATION_ID
       AND    MTL.CALENDAR_CODE is not null
       AND    MTL.CALENDAR_EXCEPTION_SET_ID is not null
       AND    MTL.ORGANIZATION_ID = x_organization_id;

Line: 181

INSERT INTO MTL_GROUP_ATPS_VIEW
  (ATP_GROUP_ID,
   ORGANIZATION_ID,
   INVENTORY_ITEM_ID,
   LAST_UPDATE_DATE,
   LAST_UPDATED_BY,
   CREATION_DATE,
   CREATED_BY,
   LAST_UPDATE_LOGIN,
   ATP_RULE_ID,
   REQUEST_QUANTITY,
   REQUEST_PRIMARY_UOM_QUANTITY,
   REQUEST_DATE,
   ATP_LEAD_TIME,
   ATP_CALENDAR_ORGANIZATION_ID,
   AVAILABLE_TO_ATP,
   UOM_CODE,
   DEMAND_CLASS,
   N_COLUMN2
  )
values
  (
   rec_mgav.ATP_GROUP_ID,
   x_ORGANIZATION_ID,
   x_INVENTORY_ITEM_ID,
   sysdate,
   -1,
   sysdate,
   -1,
   -1,
   rec_mgav.ATP_RULE_ID,
   x_REQUEST_QUANTITY,
   x_REQUEST_PRIMARY_UOM_QUANTITY,
   x_REQUEST_DATE,
   x_ATP_LEAD_TIME,
   rec_mgav.ATP_CALENDAR_ORGANIZATION_ID,
   1,
   rec_mgav.UOM_CODE,
   x_DEMAND_CLASS,
   x_N_COLUMN2
  )
;

Line: 234

end WebAtpInsert;

Line: 428

    select
      inventory_item_id,
      organization_id,
      request_quantity,
      request_primary_uom_quantity,
      request_date,
      error_code,
      group_available_date,
      request_date_atp_quantity,
      earliest_atp_date,
      earliest_atp_date_quantity,
      request_atp_date,
      request_atp_date_quantity,
      infinite_time_fence_date
    into
      x_inventory_item_id,
      x_organization_id,
      x_request_quantity,
      x_request_primary_uom_quantity,
      x_request_date,
      x_error_code,
      x_group_available_date,
      x_request_date_atp_quantity,
      x_earliest_atp_date,
      x_earliest_atp_date_quantity,
      x_request_atp_date,
      x_request_atp_date_quantity,
      x_infinite_time_fence_date
    from
      MTL_GROUP_ATPS_VIEW
    where
      ATP_GROUP_ID = x_AtpGrpId and
      n_column2    = x_n_column2;

Line: 495

      delete from mtl_group_atps_view
      where
       atp_group_id = x_AtpGrpId;