APPS.GME_POST_MIGRATION dependencies on MTL_SECONDARY_INVENTORIES

Line 1998: FROM mtl_secondary_inventories

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
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

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 2172: FROM mtl_secondary_inventories

2168: p_organization_id IN NUMBER,
2169: x_locator_type OUT NOCOPY NUMBER) IS
2170: CURSOR Cur_sub_control(v_org_id NUMBER, v_subinventory VARCHAR2) IS
2171: SELECT locator_type
2172: FROM mtl_secondary_inventories
2173: WHERE organization_id = v_org_id
2174: AND secondary_inventory_name = v_subinventory;
2175: BEGIN
2176: BEGIN

Line 2194: FROM mtl_secondary_inventories s, mtl_parameters m

2190: p_org_id IN NUMBER,
2191: x_dist_acct_id OUT NOCOPY NUMBER) IS
2192: CURSOR Cur_get_acct IS
2193: SELECT NVL(NVL(s.expense_account, s.material_account),NVL(m.expense_account, m.material_account))
2194: FROM mtl_secondary_inventories s, mtl_parameters m
2195: WHERE s.secondary_inventory_name = p_subinventory
2196: AND m.organization_id = p_org_id;
2197: BEGIN
2198: OPEN Cur_get_acct;