APPS.INV_REPLENISH_DETAIL_PUB dependencies on MTL_SYSTEM_ITEMS

Line 1034: FROM mtl_system_items

1030: SELECT 1
1031: , primary_uom_code
1032: INTO l_ato_item
1033: , l_primary_uom
1034: FROM mtl_system_items
1035: WHERE replenish_to_order_flag = 'Y'
1036: AND bom_item_type = 4
1037: AND inventory_item_id = l_mtl_reservation_tbl(1).inventory_item_id
1038: AND organization_id = l_mtl_reservation_tbl(1).organization_id;

Line 1392: FROM mtl_system_items

1388: IF l_mmtt_rec.inventory_item_id IS NOT NULL
1389: AND l_mmtt_rec.transaction_uom IS NOT NULL THEN
1390: SELECT primary_uom_code
1391: INTO l_primary_uom
1392: FROM mtl_system_items
1393: WHERE organization_id = l_mmtt_rec.organization_id
1394: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
1395:
1396: l_primary_quantity :=

Line 2571: FROM mtl_system_items

2567: , revision_qty_control_code
2568: INTO l_ser_code
2569: , l_lot_code
2570: , l_rev_code
2571: FROM mtl_system_items
2572: WHERE inventory_item_id = p_item_id
2573: AND organization_id = l_org_id;
2574:
2575: IF (l_ser_code <> 1) THEN

Line 2924: FROM mtl_system_items

2920: , revision_qty_control_code
2921: INTO l_ser_code
2922: , l_lot_code
2923: , l_rev_code
2924: FROM mtl_system_items
2925: WHERE inventory_item_id = p_item_id
2926: AND organization_id = l_org_id;
2927:
2928: IF (l_ser_code <> 1) THEN

Line 3627: FROM mtl_system_items

3623: , revision_qty_control_code
3624: INTO l_ser_code
3625: , l_lot_code
3626: , l_rev_code
3627: FROM mtl_system_items
3628: WHERE inventory_item_id = p_item_id
3629: AND organization_id = l_org_id;
3630:
3631: IF (l_ser_code <> 1) THEN