APPS.GME_POST_MIGRATION dependencies on MTL_SECONDARY_INVENTORIES

Line 1782: FROM mtl_secondary_inventories

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

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

1952: p_organization_id IN NUMBER,
1953: x_locator_type OUT NOCOPY NUMBER) IS
1954: CURSOR Cur_sub_control(v_org_id NUMBER, v_subinventory VARCHAR2) IS
1955: SELECT locator_type
1956: FROM mtl_secondary_inventories
1957: WHERE organization_id = v_org_id
1958: AND secondary_inventory_name = v_subinventory;
1959: BEGIN
1960: BEGIN

Line 1978: FROM mtl_secondary_inventories s, mtl_parameters m

1974: p_org_id IN NUMBER,
1975: x_dist_acct_id OUT NOCOPY NUMBER) IS
1976: CURSOR Cur_get_acct IS
1977: SELECT NVL(NVL(s.expense_account, s.material_account),NVL(m.expense_account, m.material_account))
1978: FROM mtl_secondary_inventories s, mtl_parameters m
1979: WHERE s.secondary_inventory_name = p_subinventory
1980: AND m.organization_id = p_org_id;
1981: BEGIN
1982: OPEN Cur_get_acct;