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_ENTITY_ATTRIBUTES

Line 439: FROM hz_entity_attributes

435: l_entity_name VARCHAR2(30);
436:
437: CURSOR c_group IS
438: SELECT attribute_group_name, attribute_name, entity_attr_id
439: FROM hz_entity_attributes
440: WHERE attribute_name IS NOT NULL
441: ORDER BY attribute_group_name;
442:
443: l_group INDEXVARCHAR30List;

Line 1736: FROM hz_entity_attributes e

1732: SELECT e.attribute_name, e.entity_attr_id,
1733: e.group_flag, s.content_source_type
1734: FROM
1735: (SELECT e.attribute_name, e.entity_attr_id, 'N' group_flag
1736: FROM hz_entity_attributes e
1737: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1738: UNION
1739: SELECT e.attribute_group_name,
1740: MIN(entity_attr_id) entity_attr_id,

Line 1742: FROM hz_entity_attributes e

1738: UNION
1739: SELECT e.attribute_group_name,
1740: MIN(entity_attr_id) entity_attr_id,
1741: 'Y' group_flag
1742: FROM hz_entity_attributes e
1743: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1744: AND NOT EXISTS (
1745: SELECT 'Y'
1746: FROM hz_entity_attributes e1

Line 1746: FROM hz_entity_attributes e1

1742: FROM hz_entity_attributes e
1743: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1744: AND NOT EXISTS (
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 (

Line 1773: FROM hz_entity_attributes e,

1769: i_normal_attributes INDEXVARCHAR30List;
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;

Line 1783: FROM hz_entity_attributes e,

1779: i_sources INDEXVARCHAR30List;
1780:
1781: CURSOR c_groups IS
1782: SELECT e.attribute_group_name, e.attribute_name
1783: FROM hz_entity_attributes e,
1784: (SELECT UNIQUE attribute_group_name
1785: FROM hz_entity_attributes
1786: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1787: GROUP BY attribute_group_name

Line 1785: FROM hz_entity_attributes

1781: CURSOR c_groups IS
1782: SELECT e.attribute_group_name, e.attribute_name
1783: FROM hz_entity_attributes e,
1784: (SELECT UNIQUE attribute_group_name
1785: FROM hz_entity_attributes
1786: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1787: GROUP BY attribute_group_name
1788: HAVING COUNT(*) > 1) e1
1789: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'

Line 1831: FROM hz_entity_attributes e,

1827: -- local variables for generating dynamic package
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'

Line 2704: FROM hz_entity_attributes e

2700: SELECT e.attribute_name, e.entity_attr_id,
2701: e.group_flag, s.content_source_type
2702: FROM
2703: (SELECT e.attribute_name, e.entity_attr_id, 'N' group_flag
2704: FROM hz_entity_attributes e
2705: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2706: AND e.updated_flag = 'Y'
2707: UNION
2708: SELECT e.attribute_group_name,

Line 2711: FROM hz_entity_attributes e

2707: UNION
2708: SELECT e.attribute_group_name,
2709: MIN(entity_attr_id) entity_attr_id,
2710: 'Y' group_flag
2711: FROM hz_entity_attributes e
2712: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2713: AND e.updated_flag = 'Y'
2714: AND NOT EXISTS (
2715: SELECT 'Y'

Line 2716: FROM hz_entity_attributes e1

2712: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2713: AND e.updated_flag = 'Y'
2714: AND NOT EXISTS (
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 (

Line 2735: FROM hz_entity_attributes e

2731: SELECT e.attribute_name, e.entity_attr_id,
2732: e.group_flag, s.content_source_type
2733: FROM
2734: (SELECT e.attribute_name, e.entity_attr_id, 'N' group_flag
2735: FROM hz_entity_attributes e
2736: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2737: UNION
2738: SELECT e.attribute_group_name,
2739: MIN(entity_attr_id) entity_attr_id,

Line 2741: FROM hz_entity_attributes e

2737: UNION
2738: SELECT e.attribute_group_name,
2739: MIN(entity_attr_id) entity_attr_id,
2740: 'Y' group_flag
2741: FROM hz_entity_attributes e
2742: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2743: AND NOT EXISTS (
2744: SELECT 'Y'
2745: FROM hz_entity_attributes e1

Line 2745: FROM hz_entity_attributes e1

2741: FROM hz_entity_attributes e
2742: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2743: AND NOT EXISTS (
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 (

Line 2772: FROM hz_entity_attributes e,

2768: i_normal_attributes INDEXVARCHAR30List;
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

Line 2787: FROM hz_entity_attributes e,

2783: -- multiple time run. We nee all the attriute which has third party
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;

Line 2797: FROM hz_entity_attributes e,

2793: i_sources INDEXVARCHAR30List;
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

Line 2810: FROM hz_entity_attributes e,

2806: i_deselected_sources INDEXVARCHAR30List;
2807:
2808: CURSOR c_groups IS
2809: SELECT e.attribute_group_name, e.attribute_name
2810: FROM hz_entity_attributes e,
2811: (SELECT UNIQUE attribute_group_name
2812: FROM hz_entity_attributes
2813: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2814: GROUP BY attribute_group_name

Line 2812: FROM hz_entity_attributes

2808: CURSOR c_groups IS
2809: SELECT e.attribute_group_name, e.attribute_name
2810: FROM hz_entity_attributes e,
2811: (SELECT UNIQUE attribute_group_name
2812: FROM hz_entity_attributes
2813: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2814: GROUP BY attribute_group_name
2815: HAVING COUNT(*) > 1) e1
2816: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'

Line 2832: FROM hz_entity_attributes e,

2828: -- return the groups which has third party data source
2829: -- used by import
2830: CURSOR c_imp_groups IS
2831: SELECT e.attribute_group_name, e.attribute_name
2832: FROM hz_entity_attributes e,
2833: (SELECT UNIQUE attribute_group_name
2834: FROM hz_entity_attributes
2835: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2836: GROUP BY attribute_group_name

Line 2834: FROM hz_entity_attributes

2830: CURSOR c_imp_groups IS
2831: SELECT e.attribute_group_name, e.attribute_name
2832: FROM hz_entity_attributes e,
2833: (SELECT UNIQUE attribute_group_name
2834: FROM hz_entity_attributes
2835: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2836: GROUP BY attribute_group_name
2837: HAVING COUNT(*) > 1) e1
2838: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'

Line 2881: FROM hz_entity_attributes e,

2877: -- local variables for generating dynamic package
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'

Line 2909: FROM hz_entity_attributes e,

2905: -- Cursor to pick attributes setup for 'By Date' method for Import Load
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'

Line 3267: li(' FROM hz_entity_attributes e ');

3263: + from setup change
3264: +=====================================*/
3265: li('CURSOR c_setup_change IS ');
3266: li(' SELECT ''Y'' ');
3267: li(' FROM hz_entity_attributes e ');
3268: li(' WHERE e.updated_flag = ''Y'' ');
3269: li(' AND rownum = 1; ');
3270: l('');
3271: li('l_call_from_setup_change VARCHAR2(10); ');

Line 4025: FROM hz_entity_attributes e,

4021:
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 (

Line 4050: FROM hz_entity_attributes e,

4046: i_normal_attributes INDEXVARCHAR30List;
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

Line 4073: FROM hz_entity_attributes

4069: e1.attribute_name,
4070: e1.entity_attr_id
4071: FROM
4072: (SELECT attribute_group_name
4073: FROM hz_entity_attributes
4074: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
4075: GROUP BY attribute_group_name
4076: HAVING COUNT(entity_attr_id) > 1
4077: ) e,

Line 4078: hz_entity_attributes e1

4074: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
4075: GROUP BY attribute_group_name
4076: HAVING COUNT(entity_attr_id) > 1
4077: ) e,
4078: hz_entity_attributes e1
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'

Line 4111: FROM hz_entity_attributes e,

4107: l_index2 NUMBER := -1;
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 (

Line 4136: FROM hz_entity_attributes

4132: e1.attribute_name,
4133: e1.entity_attr_id
4134: FROM
4135: (SELECT attribute_group_name
4136: FROM hz_entity_attributes
4137: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
4138: GROUP BY attribute_group_name
4139: HAVING COUNT(entity_attr_id) > 1
4140: ) e,

Line 4141: hz_entity_attributes e1

4137: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
4138: GROUP BY attribute_group_name
4139: HAVING COUNT(entity_attr_id) > 1
4140: ) e,
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