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.CSI_DIAGNOSTICS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 6122: hr_all_organization_units haou

6118: THEN
6119: SELECT nvl(mssi.location_id, haou.location_id)
6120: INTO l_instance_rec.location_id
6121: FROM mtl_secondary_inventories mssi,
6122: hr_all_organization_units haou
6123: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
6124: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
6125: AND haou.organization_id = mssi.organization_id;
6126: ELSIF l_instance_rec.location_type_code = 'WIP' THEN

Line 6224: hr_all_organization_units haou

6220:
6221: SELECT nvl(mssi.location_id, haou.location_id)
6222: INTO l_instance_rec.location_id
6223: FROM mtl_secondary_inventories mssi,
6224: hr_all_organization_units haou
6225: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
6226: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
6227: AND haou.organization_id = mssi.organization_id;
6228:

Line 6409: hr_all_organization_units haou

6405:
6406: SELECT nvl(mssi.location_id, haou.location_id)
6407: INTO l_instance_rec.location_id
6408: FROM mtl_secondary_inventories mssi,
6409: hr_all_organization_units haou
6410: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
6411: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
6412: AND haou.organization_id = mssi.organization_id;
6413:

Line 6705: hr_all_organization_units haou

6701:
6702: SELECT nvl(mssi.location_id, haou.location_id)
6703: INTO l_instance_rec.location_id
6704: FROM mtl_secondary_inventories mssi,
6705: hr_all_organization_units haou
6706: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
6707: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
6708: AND haou.organization_id = mssi.organization_id;
6709:

Line 7649: hr_all_organization_units haou

7645:
7646: SELECT nvl(mssi.location_id, haou.location_id)
7647: INTO l_inv_location_id
7648: FROM mtl_secondary_inventories mssi,
7649: hr_all_organization_units haou
7650: WHERE mssi.organization_id = inv_rec.organization_id
7651: AND mssi.secondary_inventory_name = inv_rec.subinv_code
7652: AND haou.organization_id = mssi.organization_id;
7653:

Line 7823: hr_all_organization_units haou

7819:
7820: SELECT nvl(mssi.location_id, haou.location_id)
7821: INTO l_instance_rec.location_id
7822: FROM mtl_secondary_inventories mssi,
7823: hr_all_organization_units haou
7824: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
7825: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
7826: AND haou.organization_id = mssi.organization_id;
7827:

Line 8386: hr_all_organization_units haou

8382:
8383: SELECT nvl(mssi.location_id, haou.location_id)
8384: INTO l_instance_rec.location_id
8385: FROM mtl_secondary_inventories mssi,
8386: hr_all_organization_units haou
8387: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
8388: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
8389: AND haou.organization_id = mssi.organization_id;
8390:

Line 8453: hr_all_organization_units haou

8449:
8450: SELECT nvl(mssi.location_id, haou.location_id)
8451: INTO l_instance_rec.location_id
8452: FROM mtl_secondary_inventories mssi,
8453: hr_all_organization_units haou
8454: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
8455: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
8456: AND haou.organization_id = mssi.organization_id;
8457:

Line 8984: FROM hr_all_organization_units

8980:
8981: IF l_instance_rec.location_id is null THEN
8982: SELECT location_id
8983: INTO l_instance_rec.location_id
8984: FROM hr_all_organization_units
8985: WHERE organization_id = l_instance_rec.vld_organization_id;
8986: END IF;
8987: END;
8988:

Line 13510: hr_all_organization_units haou

13506:
13507: SELECT nvl(mssi.location_id, haou.location_id)
13508: INTO l_instance_rec.location_id
13509: FROM mtl_secondary_inventories mssi,
13510: hr_all_organization_units haou
13511: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
13512: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
13513: AND haou.organization_id = mssi.organization_id;
13514:

Line 14752: AND EXISTS (SELECT 1 from HR_ALL_ORGANIZATION_UNITS haou

14748: AND m_msi.organization_id <> c_mp.organization_id
14749: AND c_msi.organization_id <> m_msi.organization_id
14750: AND c_msi.inventory_item_id = m_msi.inventory_item_id
14751: AND nvl(m_msi.comms_nl_trackable_flag,'N') <> nvl(c_msi.comms_nl_trackable_flag,'N')
14752: AND EXISTS (SELECT 1 from HR_ALL_ORGANIZATION_UNITS haou
14753: WHERE date_to IS NULL
14754: AND haou.organization_id =m_msi.organization_id)
14755: AND EXISTS (SELECT 1 from HR_ALL_ORGANIZATION_UNITS haou
14756: WHERE date_to IS NULL

Line 14755: AND EXISTS (SELECT 1 from HR_ALL_ORGANIZATION_UNITS haou

14751: AND nvl(m_msi.comms_nl_trackable_flag,'N') <> nvl(c_msi.comms_nl_trackable_flag,'N')
14752: AND EXISTS (SELECT 1 from HR_ALL_ORGANIZATION_UNITS haou
14753: WHERE date_to IS NULL
14754: AND haou.organization_id =m_msi.organization_id)
14755: AND EXISTS (SELECT 1 from HR_ALL_ORGANIZATION_UNITS haou
14756: WHERE date_to IS NULL
14757: AND haou.organization_id =c_msi.organization_id)
14758: ORDER BY m_msi.inventory_item_id;
14759: --