APPS.GME_POST_MIGRATION dependencies on MTL_SYSTEM_ITEMS_B

Line 2020: FROM gme_material_details d, mtl_system_items_b i

2016: CURSOR Cur_mtl_dtl(v_material_detail_id NUMBER) IS
2017: SELECT d.*, i.mtl_transactions_enabled_flag, i.reservable_type, i.segment1, i.lot_control_code,
2018: i.revision_qty_control_code, i.primary_uom_code, i.secondary_uom_code, i.restrict_subinventories_code,
2019: NVL(i.location_control_code,1) location_control_code, i.restrict_locators_code, i.segment1 item_no
2020: FROM gme_material_details d, mtl_system_items_b i
2021: WHERE d.material_detail_id = v_material_detail_id
2022: AND i.organization_id = d.organization_id
2023: AND i.inventory_item_id = d.inventory_item_id;
2024: CURSOR Cur_lot_mst(v_lot_id NUMBER) IS

Line 2867: FROM mtl_system_items_b i

2863: CURSOR Cur_item_dtl(v_organization_id NUMBER, v_inventory_item_id NUMBER) IS
2864: SELECT i.mtl_transactions_enabled_flag, i.reservable_type, i.segment1, i.lot_control_code,
2865: i.revision_qty_control_code, i.primary_uom_code, i.secondary_uom_code, i.restrict_subinventories_code,
2866: NVL(i.location_control_code,1) location_control_code, i.restrict_locators_code, i.segment1 item_no
2867: FROM mtl_system_items_b i
2868: WHERE i.organization_id = v_organization_id
2869: AND i.inventory_item_id = v_inventory_item_id;
2870: CURSOR Cur_new_loc(v_organization_id NUMBER, v_subinventory VARCHAR2, v_location VARCHAR2) IS
2871: SELECT m.inventory_location_id locator_id

Line 3424: FROM mtl_system_items_b i

3420: WHERE m.old_batch_id = l.batch_id
3421: AND NVL(attribute27, 'A') <> 'M';
3422: CURSOR Cur_item_dtl(v_organization_id NUMBER, v_inventory_item_id NUMBER) IS
3423: SELECT i.segment1, i.lot_control_code
3424: FROM mtl_system_items_b i
3425: WHERE i.organization_id = v_organization_id
3426: AND i.inventory_item_id = v_inventory_item_id;
3427: CURSOR Cur_mtl_dtl(v_material_detail_id NUMBER) IS
3428: SELECT d.*