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.HZ_GNR_UTIL_PKG dependencies on HZ_HIERARCHY_NODES

Line 3159: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3155: IF (x_map_dtls_tbl(i).GEOGRAPHY_ID IS NULL AND x_map_dtls_tbl(i).LOC_COMPVAL IS NOT NULL) THEN
3156: BEGIN
3157: SELECT g.GEOGRAPHY_ID
3158: INTO x_map_dtls_tbl(i).GEOGRAPHY_ID
3159: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3160: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3161: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3162: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3163: AND hn.HIERARCHY_TYPE = 'MASTER_REF'

Line 3230: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3226: IF l_child_geography_id IS NOT NULL THEN
3227: BEGIN
3228: SELECT g.GEOGRAPHY_ID,g.GEOGRAPHY_NAME
3229: INTO l_geography_id,l_geography_name
3230: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3231: WHERE g.GEOGRAPHY_ID = hn.PARENT_ID
3232: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE
3233: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3234: AND hn.HIERARCHY_TYPE = 'MASTER_REF'

Line 3258: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3254: IF l_child_geography_id IS NOT NULL THEN
3255: BEGIN
3256: SELECT g.GEOGRAPHY_ID,g.GEOGRAPHY_NAME
3257: INTO l_geography_id,l_geography_name
3258: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3259: -- Nishant
3260: --WHERE g.GEOGRAPHY_ID = hn.PARENT_ID
3261: WHERE g.GEOGRAPHY_ID = hn.PARENT_ID+0
3262: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE

Line 3295: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3291: ELSE -- Loc compoent value is not null and child_geo_id is null
3292: BEGIN
3293: SELECT g.GEOGRAPHY_ID,g.GEOGRAPHY_NAME
3294: INTO l_geography_id,l_geography_name
3295: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3296: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3297: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3298: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3299: AND hn.HIERARCHY_TYPE = 'MASTER_REF'

Line 3384: FROM HZ_HIERARCHY_NODES hn

3380: IF (x_map_dtls_tbl(i).GEOGRAPHY_ID IS NULL AND x_map_dtls_tbl(i).LOC_COMPVAL IS NULL) THEN
3381: BEGIN
3382: SELECT hn.CHILD_ID
3383: INTO x_map_dtls_tbl(i).GEOGRAPHY_ID
3384: FROM HZ_HIERARCHY_NODES hn
3385: WHERE hn.CHILD_OBJECT_TYPE = x_map_dtls_tbl(i).GEOGRAPHY_TYPE
3386: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3387: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3388: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'