APPS.INV_STATUS_PKG dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 305: select moqd.rowid FROM mtl_onhand_quantities_detail moqd

301: -- Added the cur_onhand for bug 6633612
302: -- Added the cursor CUR_ONHSERIAL and modified the exists clause in the cusror CUR_ONHAND for bug# 6633612
303:
304: CURSOR cur_onhand IS
305: select moqd.rowid FROM mtl_onhand_quantities_detail moqd
306: where inventory_item_id = Nvl(p_inventory_item_id, inventory_item_id)
307: and organization_id = p_organization_id
308: and subinventory_code = Nvl(p_sub_code, subinventory_code)
309: and nvl(locator_id, -9999) = nvl(p_locator_id, Nvl(locator_id, -9999))

Line 525: UPDATE mtl_onhand_quantities_detail

521: --end of bug 6952533
522: END IF;
523: END IF;
524: IF(l_serial_controlled = 0)THEN
525: UPDATE mtl_onhand_quantities_detail
526: SET status_id = p_onhand_status_id
527: , last_updated_by = FND_GLOBAL.USER_ID
528: , last_update_date = SYSDATE
529: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 614: update mtl_onhand_quantities_detail

610: OPEN cur_onhand;
611: FETCH cur_onhand BULK COLLECT INTO rowid_list ;
612: FORALL j in rowid_list.first .. rowid_list.last
613:
614: update mtl_onhand_quantities_detail
615: set status_id = p_onhand_status_id
616: , last_updated_by = FND_GLOBAL.USER_ID
617: , last_update_date = SYSDATE
618: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 1218: from mtl_onhand_quantities_detail

1214: mdebug('parent_lpn_id from wlc_cur '||l_wlc_cur.parent_lpn_id);
1215: IF l_serial_controlled = 0 THEN
1216: mdebug('Item is not serial controlled so checking moqd for status');
1217: select DISTINCT status_id INTO l_default_status_id
1218: from mtl_onhand_quantities_detail
1219: WHERE lpn_id = l_wlc_cur.parent_lpn_id
1220: AND inventory_item_id = l_wlc_cur.inventory_item_id
1221: AND NVL(lot_number,'@@@@') = NVL(l_wlc_cur.lot_number,'@@@@')
1222: AND organization_id = p_organization_id;

Line 1270: from mtl_onhand_quantities_detail

1266: mdebug('parent_lpn_id from wlc_item_cur '||l_wlc_item_cur.parent_lpn_id);
1267: IF l_serial_controlled = 0 then
1268: mdebug('Item is not serial controlled so checking moqd for status');
1269: select DISTINCT status_id into l_default_status_id
1270: from mtl_onhand_quantities_detail
1271: where lpn_id = l_wlc_item_cur.parent_lpn_id
1272: AND inventory_item_id = l_wlc_item_cur.inventory_item_id
1273: AND NVL(lot_number,'@@@@') = NVL(l_wlc_item_cur.lot_number,'@@@@')
1274: AND organization_id = p_organization_id;

Line 1358: from mtl_onhand_quantities_detail

1354: mdebug('parent_lpn_id from wlc_item_cur '||l_wlc_item_cur.parent_lpn_id);
1355: IF l_serial_controlled = 0 then
1356: mdebug('Item is not serial controlled so checking moqd for status');
1357: select DISTINCT status_id into l_default_status_id
1358: from mtl_onhand_quantities_detail
1359: where lpn_id = l_wlc_item_cur.parent_lpn_id
1360: AND inventory_item_id = l_wlc_item_cur.inventory_item_id
1361: AND NVL(lot_number,'@@@@') = NVL(l_wlc_item_cur.lot_number,'@@@@')
1362: AND organization_id = p_organization_id;