APPS.GME_POST_MIGRATION dependencies on IC_WHSE_MST

Line 1994: FROM ic_whse_mst

1990: x_subinventory OUT NOCOPY VARCHAR2,
1991: x_organization_id OUT NOCOPY NUMBER) IS
1992: CURSOR Cur_whse_mst(v_whse_code VARCHAR2) IS
1993: SELECT subinventory_ind_flag
1994: FROM ic_whse_mst
1995: WHERE whse_code = v_whse_code;
1996: CURSOR Cur_subinv_details(v_whse_code VARCHAR2) IS
1997: SELECT secondary_inventory_name, organization_id
1998: FROM mtl_secondary_inventories

Line 2002: FROM mtl_secondary_inventories s, ic_whse_mst w

1998: FROM mtl_secondary_inventories
1999: WHERE secondary_inventory_name = v_whse_code;
2000: CURSOR Cur_subinv_from_whse(v_whse_code VARCHAR2) IS
2001: SELECT s.secondary_inventory_name, s.organization_id
2002: FROM mtl_secondary_inventories s, ic_whse_mst w
2003: WHERE secondary_inventory_name = v_whse_code
2004: AND w.whse_code = s.secondary_inventory_name
2005: AND s.organization_id = w.mtl_organization_id;
2006: l_subinv_ind VARCHAR2(1);

Line 3603: FROM ic_whse_mst

3599: /* We are creating a receipt txn in a sub which has the same name as org. This will always exist */
3600: BEGIN
3601: SELECT whse_code
3602: INTO l_receipt_rec.subinventory_code
3603: FROM ic_whse_mst
3604: WHERE mtl_organization_id = p_batch_org_id;
3605: EXCEPTION
3606: WHEN OTHERS THEN
3607: l_receipt_rec.subinventory_code := gme_common_pvt.g_organization_code;