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.INV_ORGHIERARCHY_PVT dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 388: PER_ORG_STRUCTURE_VERSIONS hierv

384: hierv.org_structure_version_id
385: INTO
386: l_hierarchy_version_id
387: FROM
388: PER_ORG_STRUCTURE_VERSIONS hierv
389: WHERE
390: hierv.organization_structure_id = p_hierarchy_id
391: AND ( hierv.date_to >= SYSDATE
392: OR hierv.date_to IS NULL

Line 407: PER_ORG_STRUCTURE_VERSIONS hierv

403: hierv.org_structure_version_id
404: INTO
405: l_sec_hierarchy_version_id
406: FROM
407: PER_ORG_STRUCTURE_VERSIONS hierv
408: WHERE
409: hierv.organization_structure_id = l_sec_hierarchy_id
410: AND ( hierv.date_to >= SYSDATE
411: OR hierv.date_to IS NULL

Line 501: per_org_structure_versions sv

497: CURSOR hierarchy_version_csr IS
498: SELECT
499: sv.org_structure_version_id
500: FROM
501: per_org_structure_versions sv
502: , per_organization_structures s
503: WHERE
504: sv.organization_structure_id = s.organization_structure_id
505: AND SYSDATE >= sv.date_from

Line 1277: PER_ORG_STRUCTURE_VERSIONS OSV,

1273: SELECT
1274: OSV.org_structure_version_id
1275: , OSV.business_group_id
1276: FROM
1277: PER_ORG_STRUCTURE_VERSIONS OSV,
1278: PER_ORGANIZATION_STRUCTURES OS
1279: WHERE
1280: OSV.ORGANIZATION_STRUCTURE_ID = OS.ORGANIZATION_STRUCTURE_ID
1281: