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 385: PER_ORG_STRUCTURE_VERSIONS hierv

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

Line 404: PER_ORG_STRUCTURE_VERSIONS hierv

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

Line 498: per_org_structure_versions sv

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

Line 994: PER_ORG_STRUCTURE_VERSIONS OSV,

990: SELECT
991: OSV.org_structure_version_id
992: , OSV.business_group_id
993: FROM
994: PER_ORG_STRUCTURE_VERSIONS OSV,
995: PER_ORGANIZATION_STRUCTURES OS
996: WHERE
997: OSV.ORGANIZATION_STRUCTURE_ID = OS.ORGANIZATION_STRUCTURE_ID
998: