APPS.AMS_PHYSICAL_FULFILLMENT_PUB SQL Statements

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

Line: 36

  SELECT delv.INVENTORY_ITEM_ID
   FROM ams_deliverables_all_b delv
  WHERE delv.deliverable_id = p_collateral_id
  UNION
  SELECT delv.INVENTORY_ITEM_ID
  FROM ams_deliverables_all_b delv,
       mtl_system_items_b msi
  WHERE delv.deliverable_id in (select deliverable_kit_part_id
                             FROM ams_deliv_kit_items
                            WHERE deliverable_kit_id = p_collateral_id)
    AND delv.inventory_item_id is not null
    AND nvl(delv.kit_flag,'N')='N'
    AND delv.status_code='AVAILABLE'
    AND delv.active_flag = 'Y'
    AND delv.can_fulfill_physical_flag = 'Y'
    AND delv.actual_avail_to_date > sysdate
    AND msi.inventory_item_id = delv.inventory_item_id
    AND msi.organization_id   = p_order_header_rec.inv_organization_id
    and msi.customer_order_flag = 'Y'
    and msi.shippable_item_flag = 'Y';

Line: 61

  SELECT msi.primary_uom_code
    FROM mtl_system_items_b msi
   WHERE msi.inventory_item_id = p_item_id
     AND msi.organization_id = p_order_header_rec.inv_organization_id;

Line: 161

    INSERT INTO AMS_REQUEST_HISTORY
      ( REQUEST_HISTORY_ID
       ,ORDER_ID
       ,COLLATERAL_ID
       ,COVER_LETTER_ID
       ,CREATED_BY
       ,CREATION_DATE
       ,LAST_UPDATED_BY
       ,LAST_UPDATE_DATE
       ,LAST_UPDATE_LOGIN
      )
    VALUES
      (
         ams_request_history_s.nextval
        ,x_order_header_rec.order_header_id
        ,p_order_header_rec.collateral_id
        ,p_order_header_rec.cover_letter_id
        ,fnd_global.user_id
        ,sysdate
        ,fnd_global.user_id
        ,sysdate
        ,fnd_global.conc_login_id
     );