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 1418: from hz_select_data_sources

1414: p_entity_name IN VARCHAR2,
1415: p_purpose IN VARCHAR2) IS
1416: cursor data_sources is
1417: select content_source_type
1418: from hz_select_data_sources
1419: where entity_attr_id = attr_id
1420: and ranking <> 0;
1421:
1422: i_content_source_type INDEXVARCHAR30List;

Line 1539: from hz_select_data_sources

1535: p_entity_name IN VARCHAR2,
1536: p_purpose IN VARCHAR2) IS
1537: cursor data_sources is
1538: select content_source_type
1539: from hz_select_data_sources
1540: where entity_attr_id = attr_id
1541: and ranking <> 0;
1542:
1543: i_content_source_type INDEXVARCHAR30List;

Line 1663: hz_select_data_sources s

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 (
1665: SELECT 'Y'
1666: FROM hz_select_data_sources s1
1667: WHERE s1.entity_attr_id = e.entity_attr_id

Line 1666: FROM hz_select_data_sources s1

1662: GROUP BY e.attribute_group_name) e,
1663: hz_select_data_sources s
1664: WHERE EXISTS (
1665: SELECT 'Y'
1666: FROM hz_select_data_sources s1
1667: WHERE s1.entity_attr_id = e.entity_attr_id
1668: AND s1.content_source_type <> 'USER_ENTERED'
1669: AND s1.ranking > 0 )
1670: AND s.entity_attr_id = e.entity_attr_id

Line 1688: hz_select_data_sources s

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;
1692:

Line 1708: FROM hz_select_data_sources s1

1704: AND e.attribute_group_name = e1.attribute_group_name
1705: AND e.attribute_group_name <> e.attribute_name
1706: AND EXISTS (
1707: SELECT 'Y'
1708: FROM hz_select_data_sources s1
1709: WHERE s1.entity_attr_id = e.entity_attr_id
1710: AND s1.content_source_type <> 'USER_ENTERED'
1711: AND s1.ranking > 0 );
1712:

Line 1745: hz_select_data_sources s

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'
1749: FROM hz_select_data_sources s1

Line 1749: FROM hz_select_data_sources s1

1745: hz_select_data_sources s
1746: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
1747: AND EXISTS (
1748: SELECT 'Y'
1749: FROM hz_select_data_sources s1
1750: WHERE s1.entity_attr_id = e.entity_attr_id
1751: AND s1.ranking < 0 )
1752: AND s.entity_attr_id = e.entity_attr_id
1753: AND s.ranking < 0

Line 2619: hz_select_data_sources s

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 (
2621: SELECT 'Y'
2622: FROM hz_select_data_sources s1
2623: WHERE s1.entity_attr_id = e.entity_attr_id

Line 2622: FROM hz_select_data_sources s1

2618: GROUP BY e.attribute_group_name) e,
2619: hz_select_data_sources s
2620: WHERE /*EXISTS (
2621: SELECT 'Y'
2622: FROM hz_select_data_sources s1
2623: WHERE s1.entity_attr_id = e.entity_attr_id
2624: AND s1.content_source_type <> 'USER_ENTERED'
2625: AND s1.ranking > 0 )
2626: AND */ s.entity_attr_id = e.entity_attr_id

Line 2648: hz_select_data_sources s

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 (
2650: SELECT 'Y'
2651: FROM hz_select_data_sources s1
2652: WHERE s1.entity_attr_id = e.entity_attr_id

Line 2651: FROM hz_select_data_sources s1

2647: GROUP BY e.attribute_group_name) e,
2648: hz_select_data_sources s
2649: WHERE /*EXISTS (
2650: SELECT 'Y'
2651: FROM hz_select_data_sources s1
2652: WHERE s1.entity_attr_id = e.entity_attr_id
2653: AND s1.content_source_type <> 'USER_ENTERED'
2654: AND s1.ranking > 0 )
2655: AND*/ s.entity_attr_id = e.entity_attr_id

Line 2673: hz_select_data_sources s

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
2677: AND s.ranking > 0;

Line 2688: hz_select_data_sources s

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;
2692:

Line 2698: hz_select_data_sources s

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
2702: AND s.ranking = 0

Line 2722: FROM hz_select_data_sources s1

2718: AND e.attribute_group_name <> e.attribute_name
2719: AND e.updated_flag = 'Y'
2720: AND 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: ;

Line 2743: FROM hz_select_data_sources s1

2739: AND e.attribute_group_name = e1.attribute_group_name
2740: AND e.attribute_group_name <> e.attribute_name
2741: AND EXISTS (
2742: SELECT 'Y'
2743: FROM hz_select_data_sources s1
2744: WHERE s1.entity_attr_id = e.entity_attr_id
2745: -- AND s1.content_source_type <> 'USER_ENTERED'
2746: AND s1.ranking > 0 );
2747:

Line 2781: hz_select_data_sources s

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'
2785: FROM hz_select_data_sources s1

Line 2785: FROM hz_select_data_sources s1

2781: hz_select_data_sources s
2782: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2783: AND EXISTS (
2784: SELECT 'Y'
2785: FROM hz_select_data_sources s1
2786: WHERE s1.entity_attr_id = e.entity_attr_id
2787: AND s1.ranking < 0 )
2788: AND s.entity_attr_id = e.entity_attr_id
2789: AND e.updated_flag = 'Y'

Line 2809: hz_select_data_sources s

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'
2813: FROM hz_select_data_sources s1

Line 2813: FROM hz_select_data_sources s1

2809: hz_select_data_sources s
2810: WHERE e.entity_name = 'HZ_'||UPPER(p_entity_name)||'_PROFILES'
2811: AND EXISTS (
2812: SELECT 'Y'
2813: FROM hz_select_data_sources s1
2814: WHERE s1.entity_attr_id = e.entity_attr_id
2815: AND s1.ranking < 0 )
2816: AND s.entity_attr_id = e.entity_attr_id
2817: AND s.ranking < 0

Line 3858: hz_select_data_sources s

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 (
3862: SELECT 'Y'

Line 3863: FROM hz_select_data_sources s1

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 (
3862: SELECT 'Y'
3863: FROM hz_select_data_sources s1
3864: WHERE s1.entity_attr_id = e.entity_attr_id
3865: AND s1.content_source_type <> 'USER_ENTERED'
3866: AND s1.ranking > 0 )
3867: AND s.entity_attr_id = e.entity_attr_id

Line 3883: hz_select_data_sources s

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
3887: AND s.ranking > 0;

Line 3915: FROM hz_select_data_sources s1

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'
3915: FROM hz_select_data_sources s1
3916: WHERE s1.entity_attr_id = e1.entity_attr_id
3917: AND s1.content_source_type <> 'USER_ENTERED'
3918: AND s1.ranking <> 0 )
3919: ORDER BY e.attribute_group_name, primary_entity_attr_id;

Line 3944: hz_select_data_sources s

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 (
3948: SELECT 'Y'

Line 3949: FROM hz_select_data_sources s1

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 (
3948: SELECT 'Y'
3949: FROM hz_select_data_sources s1
3950: WHERE s1.entity_attr_id = e.entity_attr_id
3951: AND s1.ranking < 0 )
3952: AND s.entity_attr_id = e.entity_attr_id
3953: AND s.ranking < 0

Line 3977: FROM hz_select_data_sources s1

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
3978: WHERE s1.entity_attr_id = e1.entity_attr_id
3979: AND s1.ranking < 0 )
3980: ORDER BY e.attribute_group_name, primary_entity_attr_id;
3981: */