APPS.INV_STATUS_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 327: (select 1 from mtl_system_items_b msi

323: and nvl(moqd.lpn_id, -9999) = nvl(mmsh.lpn_id , -9999)
324: and nvl(moqd.lot_number, '@@@@') BETWEEN nvl (mmsh.lot_number, Nvl(moqd.lot_number, '@@@@'))
325: and nvl (mmsh.lot_number, Nvl(moqd.lot_number, '@@@@'))
326: and exists
327: (select 1 from mtl_system_items_b msi
328: where moqd.inventory_item_id = msi.inventory_item_id
329: AND moqd.organization_id = msi.organization_id
330: AND msi.serial_number_control_code in (1,6)
331: )

Line 348: (select 1 from mtl_system_items_b msi

344: and nvl(msn.lot_number, '@@@@') BETWEEN nvl (mmsh.lot_number, Nvl(msn.lot_number, '@@@@'))
345: and nvl (mmsh.lot_number, Nvl(msn.lot_number, '@@@@'))
346: and current_status = 3
347: and exists
348: (select 1 from mtl_system_items_b msi
349: where msn.inventory_item_id = msi.inventory_item_id
350: AND msn.current_organization_id = msi.organization_id
351: AND nvl(msi.serial_status_enabled, 'N') = 'Y'
352: )

Line 638: (select 1 from mtl_system_items_b msi

634: OR (nvl(lpn_id, -9999) = nvl(p_lpn_id, Nvl(lpn_id, -9999)) AND (p_lpn_indicator=0))) --bug12621577 modifying changes done in Bug 7012984
635: and nvl(lot_number, '@@@@') BETWEEN nvl (p_from_lot_number, Nvl(lot_number, '@@@@'))
636: and nvl (p_to_lot_number, Nvl(lot_number, '@@@@'))
637: and exists
638: (select 1 from mtl_system_items_b msi
639: where moqd.inventory_item_id = msi.inventory_item_id
640: AND moqd.organization_id = msi.organization_id
641: AND msi.serial_number_control_code in (1,6)
642: )

Line 671: (select 1 from mtl_system_items_b msi

667: and nvl(lot_number, '@@@@') BETWEEN nvl (p_from_lot_number, Nvl(lot_number, '@@@@'))
668: and nvl (p_to_lot_number, Nvl(lot_number, '@@@@'))
669: and current_status = 3
670: and exists
671: (select 1 from mtl_system_items_b msi
672: where msn.inventory_item_id = msi.inventory_item_id
673: AND msn.current_organization_id = msi.organization_id
674: AND nvl(msi.serial_status_enabled, 'N') = 'Y'
675: )