APPS.JTF_FULFILLMENT_PUB SQL Statements

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

Line: 70

  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: 95

  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;