APPS.WIP_RESERVATIONS_GRP SQL Statements

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

Line: 72

   SELECT
     (WDJ.START_QUANTITY - WDJ.QUANTITY_COMPLETED - WDJ.QUANTITY_SCRAPPED) ,
      MSIK.PRIMARY_UOM_CODE
   INTO
      x_available_quantity ,
      x_source_primary_uom_code
   FROM WIP_DISCRETE_JOBS WDJ ,
        MTL_SYSTEM_ITEMS_KFV MSIK
   WHERE  WDJ.WIP_ENTITY_ID = p_supply_demand_header_id
     AND WDJ.PRIMARY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
     AND WDJ.ORGANIZATION_ID = MSIK.ORGANIZATION_ID ;

Line: 85

   SELECT NVL(SUM(mtrl.primary_quantity),0)
     INTO l_crossDock_qty
     FROM mtl_txn_request_lines mtrl,
          wms_license_plate_numbers wlpn
    WHERE mtrl.organization_id = p_organization_id
      AND mtrl.inventory_item_id = p_item_id
      AND NVL(mtrl.quantity_delivered, 0) = 0
      AND mtrl.txn_source_id = p_supply_demand_header_id
      AND mtrl.lpn_id = wlpn.lpn_id
      AND wlpn.lpn_context = 2 -- WIP
      AND mtrl.line_status <> inv_globals.g_to_status_closed;

Line: 99

   SELECT
     (WDJ.START_QUANTITY - WDJ.QUANTITY_COMPLETED - WDJ.QUANTITY_SCRAPPED) +
     WDJ.QUANTITY_COMPLETED,
      MSIK.PRIMARY_UOM_CODE
   INTO
      x_available_quantity ,
      x_source_primary_uom_code
   FROM WIP_DISCRETE_JOBS WDJ ,
        MTL_SYSTEM_ITEMS_KFV MSIK
   WHERE  WDJ.WIP_ENTITY_ID = p_supply_demand_header_id
     AND WDJ.PRIMARY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
     AND WDJ.ORGANIZATION_ID = MSIK.ORGANIZATION_ID ;

Line: 198

      quantity_completed will be updated after a call to this API. This mean
      availableQty will always be zero if user already complete the whole
      quantity.
    */
   SELECT
 --     (WDJ.START_QUANTITY -WDJ.QUANTITY_COMPLETED - WDJ.QUANTITY_SCRAPPED) ,
        WDJ.STATUS_TYPE
   INTO
 --      l_available_qty,
       l_status_type
   FROM WIP_DISCRETE_JOBS WDJ
   WHERE
        WDJ.WIP_ENTITY_ID = p_supply_demand_header_id ;

Line: 212

   SELECT NVL(SUM(mtrl.primary_quantity),0)
     INTO l_crossDock_qty
     FROM mtl_txn_request_lines mtrl,
          wms_license_plate_numbers wlpn
    WHERE mtrl.organization_id = p_organization_id
      AND mtrl.inventory_item_id = p_item_id
      AND NVL(mtrl.quantity_delivered, 0) = 0
      AND mtrl.txn_source_id = p_supply_demand_header_id
      AND mtrl.lpn_id = wlpn.lpn_id
      AND wlpn.lpn_context = 2 -- WIP
      AND mtrl.line_status <> inv_globals.g_to_status_closed;