APPS.INV_ORGHIERARCHY_PVT dependencies on MTL_PARAMETERS

Line 189: mtl_parameters mp

185: )
186: ),
187: hr_all_organization_units org,
188: hr_organization_information hoi,
189: mtl_parameters mp
190: WHERE
191: org.organization_id = hoi.organization_id
192: AND org.organization_id = mp.organization_id
193: AND hoi.org_information1 = 'INV'

Line 231: , mtl_parameters mp

227: )
228:
229: , hr_all_organization_units org
230: , hr_organization_information hoi
231: , mtl_parameters mp
232:
233:
234: WHERE
235: -- only inventory organizations as part of bug#2563291 fix

Line 306: , mtl_parameters mp

302:
303:
304: , hr_all_organization_units org
305: , hr_organization_information hoi
306: , mtl_parameters mp
307:
308:
309: WHERE
310: -- only inventory organizations as part of bug#2563291 fix

Line 1284: FROM mtl_parameters

1280: l_org_id := p_org_id_tbl(i);
1281: BEGIN
1282: SELECT master_organization_id
1283: INTO l_master_org_id
1284: FROM mtl_parameters
1285: WHERE organization_id = l_org_id;
1286:
1287: EXCEPTION
1288: WHEN NO_DATA_FOUND THEN

Line 1510: FROM MTL_PARAMETERS

1506:
1507: -- cursor to obtain item master organization id
1508: CURSOR c_item_master(c_organization_id NUMBER) IS
1509: SELECT master_organization_id
1510: FROM MTL_PARAMETERS
1511: WHERE ORGANIZATION_ID = c_organization_id;
1512:
1513: -- cursor to obtain chart of accounts id for the organization
1514: CURSOR c_chart_of_accounts(c_organization_id NUMBER) IS