APPS.INV_STATUS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 111: FROM mtl_system_items

107: BEGIN
108:
109: SELECT SERIAL_NUMBER_CONTROL_CODE
110: INTO l_item_serial_check
111: FROM mtl_system_items
112: WHERE organization_id = p_org_id
113: AND inventory_item_id = p_item_id;
114:
115: IF (l_item_serial_check IN (1,6)) THEN

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: )

Line 1759: FROM mtl_system_items_kfv

1755: x_sec_qty := NULL;
1756: x_sec_uom := NULL;
1757: ELSE
1758: SELECT tracking_quantity_ind INTO p_tracking_qty_ind
1759: FROM mtl_system_items_kfv
1760: WHERE inventory_item_id = p_item_id
1761: AND organization_id = p_org_id;
1762: IF p_tracking_qty_ind = 'P' THEN
1763: x_sec_qty := NULL;