eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_STATUS_PKG dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 122: mtl_onhand_quantities_detail moqd

118: mdebug('Item is not serial controlled');
119: select mms.status_code
120: into x_status_code
121: from mtl_material_statuses mms ,
122: mtl_onhand_quantities_detail moqd
123: where mms.status_id = moqd.status_id
124: and moqd.organization_id = p_org_id
125: and moqd.inventory_item_id = p_item_id
126: AND moqd.subinventory_code = p_sub_inv

Line 317: mtl_onhand_quantities_detail moqd,

313: TYPE rowidtab1 IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
314:
315: CURSOR cur_onhand IS
316: select moqd.rowid FROM
317: mtl_onhand_quantities_detail moqd,
318: mtl_material_status_history mmsh
319: where moqd.inventory_item_id = mmsh.inventory_item_id
320: and moqd.organization_id = mmsh.organization_id
321: and moqd.subinventory_code = mmsh.zone_code

Line 421: update mtl_onhand_quantities_detail

417: OPEN cur_onhand;
418: FETCH cur_onhand BULK COLLECT INTO rowid_list ;
419:
420: FORALL j in rowid_list.first .. rowid_list.last
421: update mtl_onhand_quantities_detail
422: set status_id = p_status_id
423: , last_updated_by = FND_GLOBAL.USER_ID
424: , last_update_date = SYSDATE
425: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 628: select moqd.rowid FROM mtl_onhand_quantities_detail moqd

624: -- Added the cur_onhand for bug 6633612
625: -- Added the cursor CUR_ONHSERIAL and modified the exists clause in the cusror CUR_ONHAND for bug# 6633612
626:
627: CURSOR cur_onhand IS
628: select moqd.rowid FROM mtl_onhand_quantities_detail moqd
629: where inventory_item_id = Nvl(p_inventory_item_id, inventory_item_id)
630: and organization_id = p_organization_id
631: and subinventory_code = Nvl(p_sub_code, subinventory_code)
632: and nvl(locator_id, -9999) = nvl(p_locator_id, Nvl(locator_id, -9999))

Line 648: FROM mtl_onhand_quantities_detail moqd

644: --Bug#11826279
645: CURSOR cur_onhand_status IS
646: select moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.locator_id,moqd.lot_number,moqd.lpn_id,
647: Sum(moqd.primary_transaction_quantity) primary_onhand
648: FROM mtl_onhand_quantities_detail moqd
649: where inventory_item_id = Nvl(p_inventory_item_id, inventory_item_id)
650: and organization_id = p_organization_id
651: and subinventory_code = Nvl(p_sub_code, subinventory_code)
652: and nvl(locator_id, -9999) = nvl(p_locator_id, Nvl(locator_id, -9999))

Line 1048: UPDATE mtl_onhand_quantities_detail

1044: --end of bug 6952533
1045: END IF;
1046: END IF;
1047: IF(l_serial_controlled = 0)THEN
1048: UPDATE mtl_onhand_quantities_detail
1049: SET status_id = p_onhand_status_id
1050: , last_updated_by = FND_GLOBAL.USER_ID
1051: , last_update_date = SYSDATE
1052: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 1190: from mtl_onhand_quantities_detail moqd

1186: l_count := l_count + 1;
1187:
1188: begin
1189: select status_id into l_old_status_id
1190: from mtl_onhand_quantities_detail moqd
1191: where inventory_item_id = Nvl(p_inventory_item_id, inventory_item_id)
1192: and organization_id = p_organization_id
1193: and subinventory_code = Nvl(p_sub_code, subinventory_code)
1194: and nvl(locator_id, -9999) = nvl(p_locator_id, Nvl(locator_id, -9999))

Line 1260: update mtl_onhand_quantities_detail

1256: OPEN cur_onhand;
1257: FETCH cur_onhand BULK COLLECT INTO rowid_list ;
1258: FORALL j in rowid_list.first .. rowid_list.last
1259:
1260: update mtl_onhand_quantities_detail
1261: set status_id = p_onhand_status_id
1262: , last_updated_by = FND_GLOBAL.USER_ID
1263: , last_update_date = SYSDATE
1264: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 1840: from mtl_onhand_quantities_detail

1836: mdebug('parent_lpn_id from wlc_cur '||l_wlc_cur.parent_lpn_id);
1837: IF l_serial_controlled = 0 THEN
1838: mdebug('Item is not serial controlled so checking moqd for status');
1839: select DISTINCT status_id INTO l_default_status_id
1840: from mtl_onhand_quantities_detail
1841: WHERE lpn_id = l_wlc_cur.parent_lpn_id
1842: AND inventory_item_id = l_wlc_cur.inventory_item_id
1843: AND NVL(lot_number,'@@@@') = NVL(l_wlc_cur.lot_number,'@@@@')
1844: AND organization_id = p_organization_id;

Line 1892: from mtl_onhand_quantities_detail

1888: mdebug('parent_lpn_id from wlc_item_cur '||l_wlc_item_cur.parent_lpn_id);
1889: IF l_serial_controlled = 0 then
1890: mdebug('Item is not serial controlled so checking moqd for status');
1891: select DISTINCT status_id into l_default_status_id
1892: from mtl_onhand_quantities_detail
1893: where lpn_id = l_wlc_item_cur.parent_lpn_id
1894: AND inventory_item_id = l_wlc_item_cur.inventory_item_id
1895: AND NVL(lot_number,'@@@@') = NVL(l_wlc_item_cur.lot_number,'@@@@')
1896: AND organization_id = p_organization_id;

Line 1980: from mtl_onhand_quantities_detail

1976: mdebug('parent_lpn_id from wlc_item_cur '||l_wlc_item_cur.parent_lpn_id);
1977: IF l_serial_controlled = 0 then
1978: mdebug('Item is not serial controlled so checking moqd for status');
1979: select DISTINCT status_id into l_default_status_id
1980: from mtl_onhand_quantities_detail
1981: where lpn_id = l_wlc_item_cur.parent_lpn_id
1982: AND inventory_item_id = l_wlc_item_cur.inventory_item_id
1983: AND NVL(lot_number,'@@@@') = NVL(l_wlc_item_cur.lot_number,'@@@@')
1984: AND organization_id = p_organization_id;