APPS.INV_UPDATE_ONHAND_STATUS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 37: SELECT rowid FROM mtl_onhand_quantities_detail moqd

33: l_count NUMBER := 0;
34: l_record_count NUMBER := 0;
35:
36: CURSOR c_moqd(org_id IN NUMBER, l_bulk_limit IN NUMBER) IS
37: SELECT rowid FROM mtl_onhand_quantities_detail moqd
38: WHERE moqd.organization_id = org_id
39: AND moqd.status_id is NULL
40: AND rownum < l_bulk_limit
41: AND EXISTS(

Line 143: UPDATE mtl_onhand_quantities_detail moqd

139: EXIT;
140: END IF;
141:
142: FORALL j in rowid_list.first..rowid_list.last
143: UPDATE mtl_onhand_quantities_detail moqd
144: SET status_id = inv_material_status_grp.get_default_status_conc(moqd.organization_id,
145: moqd.inventory_item_id,
146: moqd.subinventory_code,
147: moqd.locator_id,

Line 166: FROM mtl_onhand_quantities_detail moqd, mtl_system_items_b msi

162:
163: --BEGIN
164: SELECT Count(1)
165: INTO l_count
166: FROM mtl_onhand_quantities_detail moqd, mtl_system_items_b msi
167: WHERE moqd.inventory_item_id = msi.inventory_item_id
168: AND moqd.organization_id = msi.organization_id
169: AND moqd.organization_id = orgid_list(i)
170: AND msi.serial_number_control_code in (1,6)