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 3170: FROM HZ_GEOGRAPHY_IDENTIFIERS gi

3166: AND hn.PARENT_OBJECT_TYPE = l_parent_geography_type
3167: AND SYSDATE between hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3168: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE
3169: AND EXISTS (SELECT NULL
3170: FROM HZ_GEOGRAPHY_IDENTIFIERS gi
3171: WHERE g.GEOGRAPHY_ID = gi.GEOGRAPHY_ID
3172: AND gi.GEOGRAPHY_TYPE = g.GEOGRAPHY_TYPE
3173: AND gi.GEOGRAPHY_USE = 'MASTER_REF'
3174: AND upper(gi.IDENTIFIER_VALUE) = upper(x_map_dtls_tbl(i).LOC_COMPVAL));

Line 3272: FROM HZ_GEOGRAPHY_IDENTIFIERS gi

3268: AND hn.CHILD_OBJECT_TYPE = l_child_geography_type
3269: AND SYSDATE BETWEEN hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3270: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE
3271: AND EXISTS (SELECT NULL
3272: FROM HZ_GEOGRAPHY_IDENTIFIERS gi
3273: WHERE g.GEOGRAPHY_ID = gi.GEOGRAPHY_ID
3274: AND gi.GEOGRAPHY_TYPE = g.GEOGRAPHY_TYPE
3275: AND gi.geography_type = x_map_dtls_tbl(p_iteration).GEOGRAPHY_TYPE
3276: AND gi.GEOGRAPHY_USE = 'MASTER_REF'

Line 3307: FROM HZ_GEOGRAPHY_IDENTIFIERS gi

3303: AND hn.PARENT_OBJECT_TYPE = l_country_geo_type
3304: AND SYSDATE BETWEEN hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3305: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE
3306: AND EXISTS (SELECT NULL
3307: FROM HZ_GEOGRAPHY_IDENTIFIERS gi
3308: WHERE g.GEOGRAPHY_ID = gi.GEOGRAPHY_ID
3309: AND gi.GEOGRAPHY_TYPE = g.GEOGRAPHY_TYPE
3310: AND gi.GEOGRAPHY_USE = 'MASTER_REF'
3311: AND gi.geography_type = x_map_dtls_tbl(p_iteration).GEOGRAPHY_TYPE