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_GEOGRAPHY_IDENTIFIERS

Line 1504: l_where := l_where||' AND EXISTS( SELECT NULL FROM HZ_GEOGRAPHY_IDENTIFIERS i'||i;

1500: IF P_MDU_TBL(i).LOC_COMPVAL IS NOT NULL THEN
1501: IF i = l_lowest_value_index THEN
1502: -- lowest passed in value will not be null in element column
1503: -- So the OR clause to deal the multiparent element column null value is not required.
1504: l_where := l_where||' AND EXISTS( SELECT NULL FROM HZ_GEOGRAPHY_IDENTIFIERS i'||i;
1505: l_where := l_where||' WHERE i'||i||'.GEOGRAPHY_TYPE = :l_type'||i;
1506: l_where := l_where||' AND i'||i||'.GEOGRAPHY_USE = ''MASTER_REF''';
1507: l_where := l_where||' AND g.'||P_MDU_TBL(i).GEO_ELEMENT_COL||'_ID = i'||i||'.GEOGRAPHY_ID ';
1508: l_where := l_where||' AND upper(i'||i||'.IDENTIFIER_VALUE) = upper(:l_val'||i||'))';

Line 1510: l_where := l_where||' AND (EXISTS( SELECT /+ index(i'||i||',HZ_GEOGRAPHY_IDENTIFIERS_U1) / NULL FROM HZ_GEOGRAPHY_IDENTIFIERS i'||i;

1506: l_where := l_where||' AND i'||i||'.GEOGRAPHY_USE = ''MASTER_REF''';
1507: l_where := l_where||' AND g.'||P_MDU_TBL(i).GEO_ELEMENT_COL||'_ID = i'||i||'.GEOGRAPHY_ID ';
1508: l_where := l_where||' AND upper(i'||i||'.IDENTIFIER_VALUE) = upper(:l_val'||i||'))';
1509: ELSE
1510: l_where := l_where||' AND (EXISTS( SELECT /*+ index(i'||i||',HZ_GEOGRAPHY_IDENTIFIERS_U1) */ NULL FROM HZ_GEOGRAPHY_IDENTIFIERS i'||i;
1511: l_where := l_where||' WHERE i'||i||'.GEOGRAPHY_TYPE = :l_type'||i;
1512: l_where := l_where||' AND i'||i||'.GEOGRAPHY_USE = ''MASTER_REF''';
1513: l_where := l_where||' AND g.'||P_MDU_TBL(i).GEO_ELEMENT_COL||'_ID = i'||i||'.GEOGRAPHY_ID ';
1514: l_where := l_where||' AND upper(i'||i||'.IDENTIFIER_VALUE) = upper(:l_val'||i||'))';

Line 1607: l_where := l_where||' AND EXISTS( SELECT NULL FROM HZ_GEOGRAPHY_IDENTIFIERS i'||i;

1603: IF P_MDU_TBL(i).LOC_COMPVAL IS NOT NULL THEN
1604: IF i = l_lowest_value_index THEN
1605: -- lowest passed in value will not be null in element column
1606: -- So the OR clause to deal the multiparent element column null value is not required.
1607: l_where := l_where||' AND EXISTS( SELECT NULL FROM HZ_GEOGRAPHY_IDENTIFIERS i'||i;
1608: l_where := l_where||' WHERE i'||i||'.GEOGRAPHY_TYPE = :l_type'||i;
1609: l_where := l_where||' AND i'||i||'.GEOGRAPHY_USE = ''MASTER_REF''';
1610: l_where := l_where||' AND g.'||P_MDU_TBL(i).GEO_ELEMENT_COL||'_ID = i'||i||'.GEOGRAPHY_ID ';
1611: l_where := l_where||' AND upper(i'||i||'.IDENTIFIER_VALUE) = upper(:l_val'||i||')';

Line 1615: l_where := l_where||' AND (EXISTS( SELECT /+ index(i'||i||',HZ_GEOGRAPHY_IDENTIFIERS_U1) / NULL FROM HZ_GEOGRAPHY_IDENTIFIERS i'||i;

1611: l_where := l_where||' AND upper(i'||i||'.IDENTIFIER_VALUE) = upper(:l_val'||i||')';
1612: l_where := l_where||' AND i'||i||'.IDENTIFIER_TYPE = ''NAME''';
1613: l_where := l_where||' AND i'||i||'.PRIMARY_FLAG = ''Y'')';
1614: ELSE
1615: l_where := l_where||' AND (EXISTS( SELECT /*+ index(i'||i||',HZ_GEOGRAPHY_IDENTIFIERS_U1) */ NULL FROM HZ_GEOGRAPHY_IDENTIFIERS i'||i;
1616: l_where := l_where||' WHERE i'||i||'.GEOGRAPHY_TYPE = :l_type'||i;
1617: l_where := l_where||' AND i'||i||'.GEOGRAPHY_USE = ''MASTER_REF''';
1618: l_where := l_where||' AND g.'||P_MDU_TBL(i).GEO_ELEMENT_COL||'_ID = i'||i||'.GEOGRAPHY_ID ';
1619: l_where := l_where||' AND upper(i'||i||'.IDENTIFIER_VALUE) = upper(:l_val'||i||')';

Line 3175: FROM HZ_GEOGRAPHY_IDENTIFIERS gi

3171: AND hn.PARENT_OBJECT_TYPE = l_parent_geography_type
3172: AND SYSDATE between hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3173: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE
3174: AND EXISTS (SELECT NULL
3175: FROM HZ_GEOGRAPHY_IDENTIFIERS gi
3176: WHERE g.GEOGRAPHY_ID = gi.GEOGRAPHY_ID
3177: AND gi.GEOGRAPHY_TYPE = g.GEOGRAPHY_TYPE
3178: AND gi.GEOGRAPHY_USE = 'MASTER_REF'
3179: AND upper(gi.IDENTIFIER_VALUE) = upper(x_map_dtls_tbl(i).LOC_COMPVAL));

Line 3277: FROM HZ_GEOGRAPHY_IDENTIFIERS gi

3273: AND hn.CHILD_OBJECT_TYPE = l_child_geography_type
3274: AND SYSDATE BETWEEN hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3275: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE
3276: AND EXISTS (SELECT NULL
3277: FROM HZ_GEOGRAPHY_IDENTIFIERS gi
3278: WHERE g.GEOGRAPHY_ID = gi.GEOGRAPHY_ID
3279: AND gi.GEOGRAPHY_TYPE = g.GEOGRAPHY_TYPE
3280: AND gi.geography_type = x_map_dtls_tbl(p_iteration).GEOGRAPHY_TYPE
3281: AND gi.GEOGRAPHY_USE = 'MASTER_REF'

Line 3312: FROM HZ_GEOGRAPHY_IDENTIFIERS gi

3308: AND hn.PARENT_OBJECT_TYPE = l_country_geo_type
3309: AND SYSDATE BETWEEN hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3310: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE
3311: AND EXISTS (SELECT NULL
3312: FROM HZ_GEOGRAPHY_IDENTIFIERS gi
3313: WHERE g.GEOGRAPHY_ID = gi.GEOGRAPHY_ID
3314: AND gi.GEOGRAPHY_TYPE = g.GEOGRAPHY_TYPE
3315: AND gi.GEOGRAPHY_USE = 'MASTER_REF'
3316: AND gi.geography_type = x_map_dtls_tbl(p_iteration).GEOGRAPHY_TYPE