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_MIXNM_DYNAMIC_PKG_GENERATOR dependencies on HZ_SELECT_DATA_SOURCES

Line 1504: from hz_select_data_sources

1500: p_entity_name IN VARCHAR2,
1501: p_purpose IN VARCHAR2) IS
1502: cursor data_sources is
1503: select content_source_type
1504: from hz_select_data_sources
1505: where entity_attr_id = attr_id
1506: and ranking <> 0;
1507:
1508: i_content_source_type INDEXVARCHAR30List;

Line 1625: from hz_select_data_sources

1621: p_entity_name IN VARCHAR2,
1622: p_purpose IN VARCHAR2) IS
1623: cursor data_sources is
1624: select content_source_type
1625: from hz_select_data_sources
1626: where entity_attr_id = attr_id
1627: and ranking <> 0;
1628:
1629: i_content_source_type INDEXVARCHAR30List;

Line 1749: hz_select_data_sources s

1745: SELECT 'Y'
1746: FROM hz_entity_attributes e1
1747: WHERE e.attribute_group_name = e1.attribute_name)
1748: GROUP BY e.attribute_group_name) e,
1749: hz_select_data_sources s
1750: WHERE EXISTS (
1751: SELECT 'Y'
1752: FROM hz_select_data_sources s1
1753: WHERE s1.entity_attr_id = e.entity_attr_id

Line 1752: FROM hz_select_data_sources s1

1748: GROUP BY e.attribute_group_name) e,
1749: hz_select_data_sources s
1750: WHERE EXISTS (
1751: SELECT 'Y'
1752: FROM hz_select_data_sources s1
1753: WHERE s1.entity_attr_id = e.entity_attr_id
1754: AND s1.content_source_type <> 'USER_ENTERED'
1755: AND s1.ranking > 0 )
1756: AND s.entity_attr_id = e.entity_attr_id

Line 1774: hz_select_data_sources s

1770:
1771: CURSOR c_sources IS
1772: SELECT UNIQUE s.content_source_type
1773: FROM hz_entity_attributes e,
1774: hz_select_data_sources s
1775: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1776: AND e.entity_attr_id = s.entity_attr_id
1777: AND s.ranking > 0;
1778:

Line 1794: FROM hz_select_data_sources s1

1790: AND e.attribute_group_name = e1.attribute_group_name
1791: AND e.attribute_group_name <> e.attribute_name
1792: AND EXISTS (
1793: SELECT 'Y'
1794: FROM hz_select_data_sources s1
1795: WHERE s1.entity_attr_id = e.entity_attr_id
1796: AND s1.content_source_type <> 'USER_ENTERED'
1797: AND s1.ranking > 0 );
1798:

Line 1832: hz_select_data_sources s

1828: -- Bug 6472658 : ORDER BY Clause added.
1829: CURSOR c_date_attributes IS
1830: SELECT distinct e.attribute_name, e.entity_attr_id
1831: FROM hz_entity_attributes e,
1832: hz_select_data_sources s
1833: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1834: AND EXISTS (
1835: SELECT 'Y'
1836: FROM hz_select_data_sources s1

Line 1836: FROM hz_select_data_sources s1

1832: hz_select_data_sources s
1833: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1834: AND EXISTS (
1835: SELECT 'Y'
1836: FROM hz_select_data_sources s1
1837: WHERE s1.entity_attr_id = e.entity_attr_id
1838: AND s1.ranking < 0 )
1839: AND s.entity_attr_id = e.entity_attr_id
1840: AND s.ranking < 0

Line 2719: hz_select_data_sources s

2715: SELECT 'Y'
2716: FROM hz_entity_attributes e1
2717: WHERE e.attribute_group_name = e1.attribute_name)
2718: GROUP BY e.attribute_group_name) e,
2719: hz_select_data_sources s
2720: WHERE /*EXISTS (
2721: SELECT 'Y'
2722: FROM hz_select_data_sources s1
2723: WHERE s1.entity_attr_id = e.entity_attr_id

Line 2722: FROM hz_select_data_sources s1

2718: GROUP BY e.attribute_group_name) e,
2719: hz_select_data_sources s
2720: WHERE /*EXISTS (
2721: SELECT 'Y'
2722: FROM hz_select_data_sources s1
2723: WHERE s1.entity_attr_id = e.entity_attr_id
2724: AND s1.content_source_type <> 'USER_ENTERED'
2725: AND s1.ranking > 0 )
2726: AND */ s.entity_attr_id = e.entity_attr_id

Line 2748: hz_select_data_sources s

2744: SELECT 'Y'
2745: FROM hz_entity_attributes e1
2746: WHERE e.attribute_group_name = e1.attribute_name)
2747: GROUP BY e.attribute_group_name) e,
2748: hz_select_data_sources s
2749: WHERE /*EXISTS (
2750: SELECT 'Y'
2751: FROM hz_select_data_sources s1
2752: WHERE s1.entity_attr_id = e.entity_attr_id

Line 2751: FROM hz_select_data_sources s1

2747: GROUP BY e.attribute_group_name) e,
2748: hz_select_data_sources s
2749: WHERE /*EXISTS (
2750: SELECT 'Y'
2751: FROM hz_select_data_sources s1
2752: WHERE s1.entity_attr_id = e.entity_attr_id
2753: AND s1.content_source_type <> 'USER_ENTERED'
2754: AND s1.ranking > 0 )
2755: AND*/ s.entity_attr_id = e.entity_attr_id

Line 2773: hz_select_data_sources s

2769:
2770: CURSOR c_sources IS
2771: SELECT UNIQUE s.content_source_type
2772: FROM hz_entity_attributes e,
2773: hz_select_data_sources s
2774: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2775: AND e.updated_flag = 'Y'
2776: AND e.entity_attr_id = s.entity_attr_id
2777: AND s.ranking > 0;

Line 2788: hz_select_data_sources s

2784: -- data source
2785: CURSOR c_imp_sources IS
2786: SELECT UNIQUE s.content_source_type
2787: FROM hz_entity_attributes e,
2788: hz_select_data_sources s
2789: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2790: AND e.entity_attr_id = s.entity_attr_id
2791: AND s.ranking > 0;
2792:

Line 2798: hz_select_data_sources s

2794:
2795: CURSOR c_deselected_sources IS
2796: SELECT s.entity_attr_id, s.content_source_type
2797: FROM hz_entity_attributes e,
2798: hz_select_data_sources s
2799: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2800: AND e.updated_flag = 'Y'
2801: AND e.entity_attr_id = s.entity_attr_id
2802: AND s.ranking = 0

Line 2822: FROM hz_select_data_sources s1

2818: AND e.attribute_group_name <> e.attribute_name
2819: AND e.updated_flag = 'Y'
2820: AND EXISTS (
2821: SELECT 'Y'
2822: FROM hz_select_data_sources s1
2823: WHERE s1.entity_attr_id = e.entity_attr_id
2824: -- AND s1.content_source_type <> 'USER_ENTERED'
2825: AND s1.ranking > 0 )
2826: ;

Line 2843: FROM hz_select_data_sources s1

2839: AND e.attribute_group_name = e1.attribute_group_name
2840: AND e.attribute_group_name <> e.attribute_name
2841: AND EXISTS (
2842: SELECT 'Y'
2843: FROM hz_select_data_sources s1
2844: WHERE s1.entity_attr_id = e.entity_attr_id
2845: -- AND s1.content_source_type <> 'USER_ENTERED'
2846: AND s1.ranking > 0 );
2847:

Line 2882: hz_select_data_sources s

2878: -- Bug 6472658 : ORDER BY Clause added.
2879: CURSOR c_date_attributes IS
2880: SELECT distinct e.attribute_name, e.entity_attr_id
2881: FROM hz_entity_attributes e,
2882: hz_select_data_sources s
2883: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2884: AND EXISTS (
2885: SELECT 'Y'
2886: FROM hz_select_data_sources s1

Line 2886: FROM hz_select_data_sources s1

2882: hz_select_data_sources s
2883: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2884: AND EXISTS (
2885: SELECT 'Y'
2886: FROM hz_select_data_sources s1
2887: WHERE s1.entity_attr_id = e.entity_attr_id
2888: AND s1.ranking < 0 )
2889: AND s.entity_attr_id = e.entity_attr_id
2890: AND e.updated_flag = 'Y'

Line 2910: hz_select_data_sources s

2906: -- Bug 6472658 : ORDER BY Clause added.
2907: CURSOR c_date_attributes_imp IS
2908: SELECT distinct e.attribute_name, e.entity_attr_id
2909: FROM hz_entity_attributes e,
2910: hz_select_data_sources s
2911: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2912: AND EXISTS (
2913: SELECT 'Y'
2914: FROM hz_select_data_sources s1

Line 2914: FROM hz_select_data_sources s1

2910: hz_select_data_sources s
2911: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2912: AND EXISTS (
2913: SELECT 'Y'
2914: FROM hz_select_data_sources s1
2915: WHERE s1.entity_attr_id = e.entity_attr_id
2916: AND s1.ranking < 0 )
2917: AND s.entity_attr_id = e.entity_attr_id
2918: AND s.ranking < 0

Line 4026: hz_select_data_sources s

4022: CURSOR c_restricted_attributes IS
4023: SELECT e.attribute_name, e.entity_attr_id,
4024: s.content_source_type
4025: FROM hz_entity_attributes e,
4026: hz_select_data_sources s
4027: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
4028: AND e.attribute_name NOT IN ('BANK_CODE','BANK_OR_BRANCH_NUMBER','BRANCH_CODE')
4029: AND EXISTS (
4030: SELECT 'Y'

Line 4031: FROM hz_select_data_sources s1

4027: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
4028: AND e.attribute_name NOT IN ('BANK_CODE','BANK_OR_BRANCH_NUMBER','BRANCH_CODE')
4029: AND EXISTS (
4030: SELECT 'Y'
4031: FROM hz_select_data_sources s1
4032: WHERE s1.entity_attr_id = e.entity_attr_id
4033: AND s1.content_source_type <> 'USER_ENTERED'
4034: AND s1.ranking > 0 )
4035: AND s.entity_attr_id = e.entity_attr_id

Line 4051: hz_select_data_sources s

4047:
4048: CURSOR c_sources IS
4049: SELECT UNIQUE s.content_source_type
4050: FROM hz_entity_attributes e,
4051: hz_select_data_sources s
4052: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
4053: AND e.attribute_name NOT IN ('BANK_CODE','BANK_OR_BRANCH_NUMBER','BRANCH_CODE')
4054: AND e.entity_attr_id = s.entity_attr_id
4055: AND s.ranking > 0;

Line 4083: FROM hz_select_data_sources s1

4079: WHERE e1.attribute_group_name = e.attribute_group_name
4080: AND e1.attribute_name NOT IN ('BANK_CODE','BANK_OR_BRANCH_NUMBER','BRANCH_CODE')
4081: AND EXISTS (
4082: SELECT 'Y'
4083: FROM hz_select_data_sources s1
4084: WHERE s1.entity_attr_id = e1.entity_attr_id
4085: AND s1.content_source_type <> 'USER_ENTERED'
4086: AND s1.ranking <> 0 )
4087: ORDER BY e.attribute_group_name, primary_entity_attr_id;

Line 4112: hz_select_data_sources s

4108: -- Bug 6472658 : ORDER BY Clause added.
4109: CURSOR c_date_attributes IS
4110: SELECT distinct e.attribute_name, e.entity_attr_id
4111: FROM hz_entity_attributes e,
4112: hz_select_data_sources s
4113: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
4114: AND e.attribute_name NOT IN ('BANK_CODE','BANK_OR_BRANCH_NUMBER','BRANCH_CODE')
4115: AND EXISTS (
4116: SELECT 'Y'

Line 4117: FROM hz_select_data_sources s1

4113: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
4114: AND e.attribute_name NOT IN ('BANK_CODE','BANK_OR_BRANCH_NUMBER','BRANCH_CODE')
4115: AND EXISTS (
4116: SELECT 'Y'
4117: FROM hz_select_data_sources s1
4118: WHERE s1.entity_attr_id = e.entity_attr_id
4119: AND s1.ranking < 0 )
4120: AND s.entity_attr_id = e.entity_attr_id
4121: AND s.ranking < 0

Line 4145: FROM hz_select_data_sources s1

4141: hz_entity_attributes e1
4142: WHERE e1.attribute_group_name = e.attribute_group_name
4143: AND EXISTS (
4144: SELECT 'Y'
4145: FROM hz_select_data_sources s1
4146: WHERE s1.entity_attr_id = e1.entity_attr_id
4147: AND s1.ranking < 0 )
4148: ORDER BY e.attribute_group_name, primary_entity_attr_id;
4149: */