DBA Data[Home] [Help]

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 70: FROM mtl_system_items_vl

66: WHERE item_id = v_item_id;
67: CURSOR Cur_get_item(v_org_id NUMBER,
68: v_inventory_item_id NUMBER) IS
69: SELECT *
70: FROM mtl_system_items_vl
71: WHERE organization_id = v_org_id
72: AND inventory_item_id = v_inventory_item_id;
73: CURSOR Cur_get_trans_whse(v_trans_id NUMBER) IS
74: SELECT whse_code