APPS.INV_UPDATE_ONHAND_STATUS dependencies on MTL_SYSTEM_ITEMS_B
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)