The following lines contain the word 'select', 'insert', 'update' or 'delete':
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 ;
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;
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 ;
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 ;
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;