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_COPY_ORGANIZATION_REPORT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 1073: FROM PER_ORG_STRUCTURE_ELEMENTS mdl

1069: , p_organization_id NUMBER
1070: )
1071: IS
1072: SELECT DISTINCT hier.NAME
1073: FROM PER_ORG_STRUCTURE_ELEMENTS mdl
1074: , PER_ORG_STRUCTURE_VERSIONS ver
1075: , PER_ORGANIZATION_STRUCTURES hier
1076: WHERE ORGANIZATION_ID_CHILD = p_model_org_id
1077: AND ver.ORG_STRUCTURE_VERSION_ID = mdl.ORG_STRUCTURE_VERSION_ID

Line 1081: FROM PER_ORG_STRUCTURE_ELEMENTS new

1077: AND ver.ORG_STRUCTURE_VERSION_ID = mdl.ORG_STRUCTURE_VERSION_ID
1078: AND hier.ORGANIZATION_STRUCTURE_ID = ver.ORGANIZATION_STRUCTURE_ID
1079: AND NOT EXISTS
1080: ( SELECT 'x'
1081: FROM PER_ORG_STRUCTURE_ELEMENTS new
1082: WHERE ORGANIZATION_ID_CHILD = p_organization_id
1083: AND new.ORG_STRUCTURE_VERSION_ID = mdl.ORG_STRUCTURE_VERSION_ID
1084: );
1085:

Line 1089: FROM PER_ORG_STRUCTURE_ELEMENTS pos

1085:
1086: CURSOR l_cnt_csr ( p_org_id NUMBER )
1087: IS
1088: SELECT COUNT(pos.ORG_STRUCTURE_ELEMENT_ID)
1089: FROM PER_ORG_STRUCTURE_ELEMENTS pos
1090: WHERE pos.ORGANIZATION_ID_CHILD = p_org_id;
1091:
1092: BEGIN
1093: IF G_DEBUG = 'Y' THEN