DBA Data[Home] [Help]

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 1661: FROM mtl_parameters

1657: l_org_id := p_org_id_tbl(i);
1658: BEGIN
1659: SELECT master_organization_id
1660: INTO l_master_org_id
1661: FROM mtl_parameters
1662: WHERE organization_id = l_org_id;
1663:
1664: EXCEPTION
1665: WHEN NO_DATA_FOUND THEN

Line 1887: FROM MTL_PARAMETERS

1883:
1884: -- cursor to obtain item master organization id
1885: CURSOR c_item_master(c_organization_id NUMBER) IS
1886: SELECT master_organization_id
1887: FROM MTL_PARAMETERS
1888: WHERE ORGANIZATION_ID = c_organization_id;
1889:
1890: -- cursor to obtain chart of accounts id for the organization
1891: CURSOR c_chart_of_accounts(c_organization_id NUMBER) IS