APPS.INV_REPLENISH_DETAIL_PUB dependencies on MTL_SYSTEM_ITEMS

Line 907: FROM mtl_system_items

903: SELECT 1
904: , primary_uom_code
905: INTO l_ato_item
906: , l_primary_uom
907: FROM mtl_system_items
908: WHERE replenish_to_order_flag = 'Y'
909: AND bom_item_type = 4
910: AND inventory_item_id = l_mtl_reservation_tbl(1).inventory_item_id
911: AND organization_id = l_mtl_reservation_tbl(1).organization_id;

Line 1260: FROM mtl_system_items

1256: IF l_mmtt_rec.inventory_item_id IS NOT NULL
1257: AND l_mmtt_rec.transaction_uom IS NOT NULL THEN
1258: SELECT primary_uom_code
1259: INTO l_primary_uom
1260: FROM mtl_system_items
1261: WHERE organization_id = l_mmtt_rec.organization_id
1262: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
1263:
1264: l_primary_quantity :=

Line 2307: FROM mtl_system_items

2303: , revision_qty_control_code
2304: INTO l_ser_code
2305: , l_lot_code
2306: , l_rev_code
2307: FROM mtl_system_items
2308: WHERE inventory_item_id = p_item_id
2309: AND organization_id = l_org_id;
2310:
2311: IF (l_ser_code <> 1) THEN

Line 2645: FROM mtl_system_items

2641: , revision_qty_control_code
2642: INTO l_ser_code
2643: , l_lot_code
2644: , l_rev_code
2645: FROM mtl_system_items
2646: WHERE inventory_item_id = p_item_id
2647: AND organization_id = l_org_id;
2648:
2649: IF (l_ser_code <> 1) THEN

Line 3189: FROM mtl_system_items

3185: , revision_qty_control_code
3186: INTO l_ser_code
3187: , l_lot_code
3188: , l_rev_code
3189: FROM mtl_system_items
3190: WHERE inventory_item_id = p_item_id
3191: AND organization_id = l_org_id;
3192:
3193: IF (l_ser_code <> 1) THEN