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 3164: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3160: IF (x_map_dtls_tbl(i).GEOGRAPHY_ID IS NULL AND x_map_dtls_tbl(i).LOC_COMPVAL IS NOT NULL) THEN
3161: BEGIN
3162: SELECT g.GEOGRAPHY_ID
3163: INTO x_map_dtls_tbl(i).GEOGRAPHY_ID
3164: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3165: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3166: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3167: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3168: AND hn.HIERARCHY_TYPE = 'MASTER_REF'

Line 3235: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3231: IF l_child_geography_id IS NOT NULL THEN
3232: BEGIN
3233: SELECT g.GEOGRAPHY_ID,g.GEOGRAPHY_NAME
3234: INTO l_geography_id,l_geography_name
3235: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3236: WHERE g.GEOGRAPHY_ID = hn.PARENT_ID
3237: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE
3238: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3239: AND hn.HIERARCHY_TYPE = 'MASTER_REF'

Line 3263: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3259: IF l_child_geography_id IS NOT NULL THEN
3260: BEGIN
3261: SELECT g.GEOGRAPHY_ID,g.GEOGRAPHY_NAME
3262: INTO l_geography_id,l_geography_name
3263: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3264: -- Nishant
3265: --WHERE g.GEOGRAPHY_ID = hn.PARENT_ID
3266: WHERE g.GEOGRAPHY_ID = hn.PARENT_ID+0
3267: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE

Line 3300: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3296: ELSE -- Loc compoent value is not null and child_geo_id is null
3297: BEGIN
3298: SELECT g.GEOGRAPHY_ID,g.GEOGRAPHY_NAME
3299: INTO l_geography_id,l_geography_name
3300: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3301: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3302: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3303: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3304: AND hn.HIERARCHY_TYPE = 'MASTER_REF'

Line 3389: FROM HZ_HIERARCHY_NODES hn

3385: IF (x_map_dtls_tbl(i).GEOGRAPHY_ID IS NULL AND x_map_dtls_tbl(i).LOC_COMPVAL IS NULL) THEN
3386: BEGIN
3387: SELECT hn.CHILD_ID
3388: INTO x_map_dtls_tbl(i).GEOGRAPHY_ID
3389: FROM HZ_HIERARCHY_NODES hn
3390: WHERE hn.CHILD_OBJECT_TYPE = x_map_dtls_tbl(i).GEOGRAPHY_TYPE
3391: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3392: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3393: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'