DBA Data[Home] [Help]

APPS.INV_STATUS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 314: (select 1 from mtl_system_items_b msi

310: and nvl(lpn_id, -9999) = nvl(p_lpn_id, -9999) -- Bug 7012984, Modified the lpn_id condition
311: and nvl(lot_number, '@@@@') BETWEEN nvl (p_from_lot_number, Nvl(lot_number, '@@@@'))
312: and nvl (p_to_lot_number, Nvl(lot_number, '@@@@'))
313: and exists
314: (select 1 from mtl_system_items_b msi
315: where moqd.inventory_item_id = msi.inventory_item_id
316: AND moqd.organization_id = msi.organization_id
317: AND msi.serial_number_control_code in (1,6)
318: )

Line 332: (select 1 from mtl_system_items_b msi

328: and nvl(lot_number, '@@@@') BETWEEN nvl (p_from_lot_number, Nvl(lot_number, '@@@@'))
329: and nvl (p_to_lot_number, Nvl(lot_number, '@@@@'))
330: and current_status = 3
331: and exists
332: (select 1 from mtl_system_items_b msi
333: where msn.inventory_item_id = msi.inventory_item_id
334: AND msn.current_organization_id = msi.organization_id
335: AND nvl(msi.serial_status_enabled, 'N') = 'Y'
336: )

Line 1137: FROM mtl_system_items_kfv

1133: x_sec_qty := NULL;
1134: x_sec_uom := NULL;
1135: ELSE
1136: SELECT tracking_quantity_ind INTO p_tracking_qty_ind
1137: FROM mtl_system_items_kfv
1138: WHERE inventory_item_id = p_item_id
1139: AND organization_id = p_org_id;
1140: IF p_tracking_qty_ind = 'P' THEN
1141: x_sec_qty := NULL;