APPS.GME_POST_MIGRATION dependencies on IC_WHSE_MST

Line 1778: FROM ic_whse_mst

1774: x_subinventory OUT NOCOPY VARCHAR2,
1775: x_organization_id OUT NOCOPY NUMBER) IS
1776: CURSOR Cur_whse_mst(v_whse_code VARCHAR2) IS
1777: SELECT subinventory_ind_flag
1778: FROM ic_whse_mst
1779: WHERE whse_code = v_whse_code;
1780: CURSOR Cur_subinv_details(v_whse_code VARCHAR2) IS
1781: SELECT secondary_inventory_name, organization_id
1782: FROM mtl_secondary_inventories

Line 1786: FROM mtl_secondary_inventories s, ic_whse_mst w

1782: FROM mtl_secondary_inventories
1783: WHERE secondary_inventory_name = v_whse_code;
1784: CURSOR Cur_subinv_from_whse(v_whse_code VARCHAR2) IS
1785: SELECT s.secondary_inventory_name, s.organization_id
1786: FROM mtl_secondary_inventories s, ic_whse_mst w
1787: WHERE secondary_inventory_name = v_whse_code
1788: AND w.whse_code = s.secondary_inventory_name
1789: AND s.organization_id = w.mtl_organization_id;
1790: l_subinv_ind VARCHAR2(1);

Line 3120: FROM ic_whse_mst

3116: /* We are creating a receipt txn in a sub which has the same name as org. This will always exist */
3117: BEGIN
3118: SELECT whse_code
3119: INTO l_receipt_rec.subinventory_code
3120: FROM ic_whse_mst
3121: WHERE mtl_organization_id = p_batch_org_id;
3122: EXCEPTION
3123: WHEN OTHERS THEN
3124: l_receipt_rec.subinventory_code := gme_common_pvt.g_organization_code;