APPS.GME_POST_MIGRATION dependencies on MTL_SYSTEM_ITEMS_VL

Line 8: l_item_rec mtl_system_items_vl%ROWTYPE;

4: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
5: PROCEDURE recreate_open_batches(err_buf OUT NOCOPY VARCHAR2,
6: ret_code OUT NOCOPY VARCHAR2) IS
7: l_api_name VARCHAR2(30) := 'RECREATE_OPEN_BATCHES';
8: l_item_rec mtl_system_items_vl%ROWTYPE;
9: l_batch_header gme_batch_header%ROWTYPE;
10: l_batch_tbl gme_common_pvt.batch_headers_tab;
11: l_mtl_dtl_mig_tbl gme_post_migration.mtl_dtl_mig_tab;
12: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;

Line 76: FROM mtl_system_items_vl

72:
73: CURSOR Cur_get_item(v_org_id NUMBER,
74: v_inventory_item_id NUMBER) IS
75: SELECT *
76: FROM mtl_system_items_vl
77: WHERE organization_id = v_org_id
78: AND inventory_item_id = v_inventory_item_id;
79:
80: CURSOR Cur_get_trans_whse(v_trans_id NUMBER) IS