eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_MTL_INVENTORY_LOC_M_SZ dependencies on HR_ORGANIZATION_INFORMATION

Line 39: HR_ORGANIZATION_INFORMATION HOI,

35: select count(*) cnt
36: FROM
37: hr_all_organization_units bg,
38: hr_all_organization_units org,
39: HR_ORGANIZATION_INFORMATION HOI,
40: mtl_parameters mp
41: WHERE bg.organization_id = org.business_group_id
42: AND org.organization_id = mp.organization_id
43: and org.ORGANIZATION_ID = HOI.ORGANIZATION_ID

Line 220: HR_ORGANIZATION_INFORMATION HOI;

216: -- OPERATING_UNIT_FK needs to add instance_code
217: -- OPM_ORGANIZATION_FK needs to add instance_code
218: 2*avg(nvl(vsize(HOI.ORG_INFORMATION3), 0))
219: From
220: HR_ORGANIZATION_INFORMATION HOI;
221:
222: CURSOR c_8 IS
223: SELECT avg(nvl(vsize(ORGN_CODE),0)) ORGN_CODE,
224: avg(nvl(vsize(ORGN_NAME),0)) ORGN_NAME