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 357: FROM hz_entity_attributes

353: l_entity_name VARCHAR2(30);
354:
355: CURSOR c_group IS
356: SELECT attribute_group_name, attribute_name, entity_attr_id
357: FROM hz_entity_attributes
358: WHERE attribute_name IS NOT NULL
359: ORDER BY attribute_group_name;
360:
361: l_group INDEXVARCHAR30List;

Line 1650: FROM hz_entity_attributes e

1646: SELECT e.attribute_name, e.entity_attr_id,
1647: e.group_flag, s.content_source_type
1648: FROM
1649: (SELECT e.attribute_name, e.entity_attr_id, 'N' group_flag
1650: FROM hz_entity_attributes e
1651: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1652: UNION
1653: SELECT e.attribute_group_name,
1654: MIN(entity_attr_id) entity_attr_id,

Line 1656: FROM hz_entity_attributes e

1652: UNION
1653: SELECT e.attribute_group_name,
1654: MIN(entity_attr_id) entity_attr_id,
1655: 'Y' group_flag
1656: FROM hz_entity_attributes e
1657: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1658: AND NOT EXISTS (
1659: SELECT 'Y'
1660: FROM hz_entity_attributes e1

Line 1660: FROM hz_entity_attributes e1

1656: FROM hz_entity_attributes e
1657: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1658: AND NOT EXISTS (
1659: SELECT 'Y'
1660: FROM hz_entity_attributes e1
1661: WHERE e.attribute_group_name = e1.attribute_name)
1662: GROUP BY e.attribute_group_name) e,
1663: hz_select_data_sources s
1664: WHERE EXISTS (

Line 1687: FROM hz_entity_attributes e,

1683: i_normal_attributes INDEXVARCHAR30List;
1684:
1685: CURSOR c_sources IS
1686: SELECT UNIQUE s.content_source_type
1687: FROM hz_entity_attributes e,
1688: hz_select_data_sources s
1689: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1690: AND e.entity_attr_id = s.entity_attr_id
1691: AND s.ranking > 0;

Line 1697: FROM hz_entity_attributes e,

1693: i_sources INDEXVARCHAR30List;
1694:
1695: CURSOR c_groups IS
1696: SELECT e.attribute_group_name, e.attribute_name
1697: FROM hz_entity_attributes e,
1698: (SELECT UNIQUE attribute_group_name
1699: FROM hz_entity_attributes
1700: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1701: GROUP BY attribute_group_name

Line 1699: FROM hz_entity_attributes

1695: CURSOR c_groups IS
1696: SELECT e.attribute_group_name, e.attribute_name
1697: FROM hz_entity_attributes e,
1698: (SELECT UNIQUE attribute_group_name
1699: FROM hz_entity_attributes
1700: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1701: GROUP BY attribute_group_name
1702: HAVING COUNT(*) > 1) e1
1703: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'

Line 1744: FROM hz_entity_attributes e,

1740: -- local variables for generating dynamic package
1741: -- Bug 6472658 : ORDER BY Clause added.
1742: CURSOR c_date_attributes IS
1743: SELECT distinct e.attribute_name, e.entity_attr_id
1744: FROM hz_entity_attributes e,
1745: hz_select_data_sources s
1746: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1747: AND EXISTS (
1748: SELECT 'Y'

Line 2604: FROM hz_entity_attributes e

2600: SELECT e.attribute_name, e.entity_attr_id,
2601: e.group_flag, s.content_source_type
2602: FROM
2603: (SELECT e.attribute_name, e.entity_attr_id, 'N' group_flag
2604: FROM hz_entity_attributes e
2605: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2606: AND e.updated_flag = 'Y'
2607: UNION
2608: SELECT e.attribute_group_name,

Line 2611: FROM hz_entity_attributes e

2607: UNION
2608: SELECT e.attribute_group_name,
2609: MIN(entity_attr_id) entity_attr_id,
2610: 'Y' group_flag
2611: FROM hz_entity_attributes e
2612: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2613: AND e.updated_flag = 'Y'
2614: AND NOT EXISTS (
2615: SELECT 'Y'

Line 2616: FROM hz_entity_attributes e1

2612: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2613: AND e.updated_flag = 'Y'
2614: AND NOT EXISTS (
2615: SELECT 'Y'
2616: FROM hz_entity_attributes e1
2617: WHERE e.attribute_group_name = e1.attribute_name)
2618: GROUP BY e.attribute_group_name) e,
2619: hz_select_data_sources s
2620: WHERE /*EXISTS (

Line 2635: FROM hz_entity_attributes e

2631: SELECT e.attribute_name, e.entity_attr_id,
2632: e.group_flag, s.content_source_type
2633: FROM
2634: (SELECT e.attribute_name, e.entity_attr_id, 'N' group_flag
2635: FROM hz_entity_attributes e
2636: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2637: UNION
2638: SELECT e.attribute_group_name,
2639: MIN(entity_attr_id) entity_attr_id,

Line 2641: FROM hz_entity_attributes e

2637: UNION
2638: SELECT e.attribute_group_name,
2639: MIN(entity_attr_id) entity_attr_id,
2640: 'Y' group_flag
2641: FROM hz_entity_attributes e
2642: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2643: AND NOT EXISTS (
2644: SELECT 'Y'
2645: FROM hz_entity_attributes e1

Line 2645: FROM hz_entity_attributes e1

2641: FROM hz_entity_attributes e
2642: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2643: AND NOT EXISTS (
2644: SELECT 'Y'
2645: FROM hz_entity_attributes e1
2646: WHERE e.attribute_group_name = e1.attribute_name)
2647: GROUP BY e.attribute_group_name) e,
2648: hz_select_data_sources s
2649: WHERE /*EXISTS (

Line 2672: FROM hz_entity_attributes e,

2668: i_normal_attributes INDEXVARCHAR30List;
2669:
2670: CURSOR c_sources IS
2671: SELECT UNIQUE s.content_source_type
2672: FROM hz_entity_attributes e,
2673: hz_select_data_sources s
2674: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2675: AND e.updated_flag = 'Y'
2676: AND e.entity_attr_id = s.entity_attr_id

Line 2687: FROM hz_entity_attributes e,

2683: -- multiple time run. We nee all the attriute which has third party
2684: -- data source
2685: CURSOR c_imp_sources IS
2686: SELECT UNIQUE s.content_source_type
2687: FROM hz_entity_attributes e,
2688: hz_select_data_sources s
2689: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2690: AND e.entity_attr_id = s.entity_attr_id
2691: AND s.ranking > 0;

Line 2697: FROM hz_entity_attributes e,

2693: i_sources INDEXVARCHAR30List;
2694:
2695: CURSOR c_deselected_sources IS
2696: SELECT s.entity_attr_id, s.content_source_type
2697: FROM hz_entity_attributes e,
2698: hz_select_data_sources s
2699: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2700: AND e.updated_flag = 'Y'
2701: AND e.entity_attr_id = s.entity_attr_id

Line 2710: FROM hz_entity_attributes e,

2706: i_deselected_sources INDEXVARCHAR30List;
2707:
2708: CURSOR c_groups IS
2709: SELECT e.attribute_group_name, e.attribute_name
2710: FROM hz_entity_attributes e,
2711: (SELECT UNIQUE attribute_group_name
2712: FROM hz_entity_attributes
2713: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2714: GROUP BY attribute_group_name

Line 2712: FROM hz_entity_attributes

2708: CURSOR c_groups IS
2709: SELECT e.attribute_group_name, e.attribute_name
2710: FROM hz_entity_attributes e,
2711: (SELECT UNIQUE attribute_group_name
2712: FROM hz_entity_attributes
2713: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2714: GROUP BY attribute_group_name
2715: HAVING COUNT(*) > 1) e1
2716: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'

Line 2732: FROM hz_entity_attributes e,

2728: -- return the groups which has third party data source
2729: -- used by import
2730: CURSOR c_imp_groups IS
2731: SELECT e.attribute_group_name, e.attribute_name
2732: FROM hz_entity_attributes e,
2733: (SELECT UNIQUE attribute_group_name
2734: FROM hz_entity_attributes
2735: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2736: GROUP BY attribute_group_name

Line 2734: FROM hz_entity_attributes

2730: CURSOR c_imp_groups IS
2731: SELECT e.attribute_group_name, e.attribute_name
2732: FROM hz_entity_attributes e,
2733: (SELECT UNIQUE attribute_group_name
2734: FROM hz_entity_attributes
2735: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2736: GROUP BY attribute_group_name
2737: HAVING COUNT(*) > 1) e1
2738: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'

Line 2780: FROM hz_entity_attributes e,

2776: -- local variables for generating dynamic package
2777: -- Bug 6472658 : ORDER BY Clause added.
2778: CURSOR c_date_attributes IS
2779: SELECT distinct e.attribute_name, e.entity_attr_id
2780: FROM hz_entity_attributes e,
2781: hz_select_data_sources s
2782: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2783: AND EXISTS (
2784: SELECT 'Y'

Line 2808: FROM hz_entity_attributes e,

2804: -- Cursor to pick attributes setup for 'By Date' method for Import Load
2805: -- Bug 6472658 : ORDER BY Clause added.
2806: CURSOR c_date_attributes_imp IS
2807: SELECT distinct e.attribute_name, e.entity_attr_id
2808: FROM hz_entity_attributes e,
2809: hz_select_data_sources s
2810: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2811: AND EXISTS (
2812: SELECT 'Y'

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

3162: + from setup change
3163: +=====================================*/
3164: li('CURSOR c_setup_change IS ');
3165: li(' SELECT ''Y'' ');
3166: li(' FROM hz_entity_attributes e ');
3167: li(' WHERE e.updated_flag = ''Y'' ');
3168: li(' AND rownum = 1; ');
3169: l('');
3170: li('l_call_from_setup_change VARCHAR2(10); ');

Line 3857: FROM hz_entity_attributes e,

3853:
3854: CURSOR c_restricted_attributes IS
3855: SELECT e.attribute_name, e.entity_attr_id,
3856: s.content_source_type
3857: FROM hz_entity_attributes e,
3858: hz_select_data_sources s
3859: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
3860: AND e.attribute_name NOT IN ('BANK_CODE','BANK_OR_BRANCH_NUMBER','BRANCH_CODE')
3861: AND EXISTS (

Line 3882: FROM hz_entity_attributes e,

3878: i_normal_attributes INDEXVARCHAR30List;
3879:
3880: CURSOR c_sources IS
3881: SELECT UNIQUE s.content_source_type
3882: FROM hz_entity_attributes e,
3883: hz_select_data_sources s
3884: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
3885: AND e.attribute_name NOT IN ('BANK_CODE','BANK_OR_BRANCH_NUMBER','BRANCH_CODE')
3886: AND e.entity_attr_id = s.entity_attr_id

Line 3905: FROM hz_entity_attributes

3901: e1.attribute_name,
3902: e1.entity_attr_id
3903: FROM
3904: (SELECT attribute_group_name
3905: FROM hz_entity_attributes
3906: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
3907: GROUP BY attribute_group_name
3908: HAVING COUNT(entity_attr_id) > 1
3909: ) e,

Line 3910: hz_entity_attributes e1

3906: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
3907: GROUP BY attribute_group_name
3908: HAVING COUNT(entity_attr_id) > 1
3909: ) e,
3910: hz_entity_attributes e1
3911: WHERE e1.attribute_group_name = e.attribute_group_name
3912: AND e1.attribute_name NOT IN ('BANK_CODE','BANK_OR_BRANCH_NUMBER','BRANCH_CODE')
3913: AND EXISTS (
3914: SELECT 'Y'

Line 3943: FROM hz_entity_attributes e,

3939: l_index2 NUMBER := -1;
3940: -- Bug 6472658 : ORDER BY Clause added.
3941: CURSOR c_date_attributes IS
3942: SELECT distinct e.attribute_name, e.entity_attr_id
3943: FROM hz_entity_attributes e,
3944: hz_select_data_sources s
3945: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
3946: AND e.attribute_name NOT IN ('BANK_CODE','BANK_OR_BRANCH_NUMBER','BRANCH_CODE')
3947: AND EXISTS (

Line 3968: FROM hz_entity_attributes

3964: e1.attribute_name,
3965: e1.entity_attr_id
3966: FROM
3967: (SELECT attribute_group_name
3968: FROM hz_entity_attributes
3969: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
3970: GROUP BY attribute_group_name
3971: HAVING COUNT(entity_attr_id) > 1
3972: ) e,

Line 3973: hz_entity_attributes e1

3969: WHERE entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
3970: GROUP BY attribute_group_name
3971: HAVING COUNT(entity_attr_id) > 1
3972: ) e,
3973: hz_entity_attributes e1
3974: WHERE e1.attribute_group_name = e.attribute_group_name
3975: AND EXISTS (
3976: SELECT 'Y'
3977: FROM hz_select_data_sources s1