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

Line 359: hz_select_data_sources s

355: SELECT s.entity_attr_id,
356: s.content_source_type,
357: s.ranking
358: FROM hz_entity_attributes e,
359: hz_select_data_sources s
360: WHERE e.entity_name = p_entity_name
361: AND s.entity_attr_id = e.entity_attr_id
362: AND s.ranking <> 0;
363: -- Bug 4156090. Order by is no longer required.

Line 398: hz_select_data_sources s1,

394: SELECT e.entity_attr_id,
395: NVL(exp.content_source_type, s1.content_source_type),
396: exp.exception_type
397: FROM hz_entity_attributes e,
398: hz_select_data_sources s1,
399: (SELECT entity_attr_id,
400: content_source_type,
401: exception_type
402: FROM hz_win_source_exceps

Line 427: and exists (select 'Y' from hz_select_data_sources s1

423: FROM hz_win_source_exceps
424: WHERE party_id = p_party_id ) exp
425: WHERE e.entity_name = p_entity_name
426: AND exp.entity_attr_id (+) = e.entity_attr_id
427: and exists (select 'Y' from hz_select_data_sources s1
428: where s1.entity_attr_id = e.entity_attr_id
429: and s1.ranking <> 0);
430:
431: -- find out the attributes which can be overwrited by user

Line 920: hz_select_data_sources s

916: CURSOR c_data_source_other IS
917: SELECT s.entity_attr_id,
918: s.content_source_type
919: FROM hz_entity_attributes e,
920: hz_select_data_sources s
921: WHERE e.entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
922: AND s.entity_attr_id = e.entity_attr_id
923: AND s.ranking > 0
924: ORDER BY s.entity_attr_id;

Line 933: hz_select_data_sources s

929: p_entity_name VARCHAR2
930: ) IS
931: SELECT UNIQUE s.content_source_type
932: FROM hz_entity_attributes e,
933: hz_select_data_sources s
934: WHERE e.entity_name = p_entity_name
935: AND s.entity_attr_id = e.entity_attr_id
936: AND s.ranking <> 0; -- SSM SST Integration and Extension -->> ranking of -1 denotes MRR
937:

Line 2543: FROM hz_select_data_sources

2539: SYSDATE,
2540: hz_utility_v2pub.last_update_login,
2541: SYSDATE,
2542: hz_utility_v2pub.last_updated_by
2543: FROM hz_select_data_sources
2544: WHERE ranking > 0
2545: and content_source_type = 'USER_ENTERED'
2546: and entity_attr_id = i_entity_attr_id(i)
2547: and i_exception_type(i) <> 'MRN';

Line 2844: FROM hz_select_data_sources

2840: SYSDATE,
2841: hz_utility_v2pub.last_update_login,
2842: SYSDATE,
2843: hz_utility_v2pub.last_updated_by
2844: FROM hz_select_data_sources
2845: WHERE ranking > 1
2846: and content_source_type = 'USER_ENTERED'
2847: and entity_attr_id = l_entity_attr_id;
2848: ELSE

Line 3717: from hz_select_data_sources d, hz_entity_attributes e

3713: -- check if policy exists.
3714: -- bug fix 2731008
3715: BEGIN
3716: select 'Y' into l_src_selected
3717: from hz_select_data_sources d, hz_entity_attributes e
3718: where e.entity_attr_id = d.entity_attr_id
3719: and UPPER(e.entity_name) = UPPER(p_entity_name)
3720: and d.content_source_type <> G_MISS_CONTENT_SOURCE_TYPE
3721: and d.ranking > 0

Line 5065: hz_select_data_sources s

5061:
5062: CURSOR c_other_setup IS
5063: SELECT 'Y'
5064: FROM hz_entity_attributes e,
5065: hz_select_data_sources s
5066: WHERE e.updated_flag = 'Y'
5067: AND e.entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
5068: AND rownum = 1;
5069:

Line 5176: FROM hz_entity_attributes e, hz_select_data_sources s

5172: IF l_process_org AND l_org_total <> 0 THEN
5173: DELETE hz_win_source_exceps
5174: WHERE entity_attr_id IN
5175: (SELECT e.entity_attr_id
5176: FROM hz_entity_attributes e, hz_select_data_sources s
5177: WHERE e.entity_name = 'HZ_ORGANIZATION_PROFILES'
5178: AND s.ranking > 0
5179: AND s.content_source_type = 'USER_ENTERED'
5180: AND e.entity_attr_id = s.entity_attr_id

Line 5188: FROM hz_entity_attributes e, hz_select_data_sources s

5184: IF l_process_person AND l_per_total <> 0 THEN
5185: DELETE hz_win_source_exceps
5186: WHERE entity_attr_id IN
5187: (SELECT e.entity_attr_id
5188: FROM hz_entity_attributes e, hz_select_data_sources s
5189: WHERE e.entity_name = 'HZ_PERSON_PROFILES'
5190: AND s.ranking > 0
5191: AND s.content_source_type = 'USER_ENTERED'
5192: AND e.entity_attr_id = s.entity_attr_id

Line 5394: from hz_entity_attributes e, hz_select_data_sources s

5390: )IS
5391:
5392: cursor mmr_attributes IS
5393: select e.entity_attr_id, s.content_source_type
5394: from hz_entity_attributes e, hz_select_data_sources s
5395: where s.ranking = -1
5396: AND e.entity_name = p_entity_name
5397: AND e.entity_attr_id = s.entity_attr_id
5398: AND (s.content_source_type= p_data_source_type or

Line 5400: NOT EXISTS(select 'Y' from hz_select_data_sources s1

5396: AND e.entity_name = p_entity_name
5397: AND e.entity_attr_id = s.entity_attr_id
5398: AND (s.content_source_type= p_data_source_type or
5399: (s.content_source_type='USER_ENTERED' AND
5400: NOT EXISTS(select 'Y' from hz_select_data_sources s1
5401: where s1.ranking = -1 and s1.content_source_type = p_data_source_type
5402: and s1.entity_attr_id = e.entity_attr_id)))
5403: -- Bug 4244112 : populate only if does not exist
5404: AND NOT EXISTS(select 'Y' from hz_win_source_exceps

Line 5409: TYPE SOURCE_List IS TABLE OF hz_select_data_sources.content_source_type%TYPE;

5405: where party_id = p_party_id
5406: and entity_attr_id = e.entity_attr_id);
5407:
5408: TYPE ATTR_IDList IS TABLE OF hz_entity_attributes.entity_attr_id%TYPE;
5409: TYPE SOURCE_List IS TABLE OF hz_select_data_sources.content_source_type%TYPE;
5410: I_ATTR_ID ATTR_IDList;
5411: I_SOURCE SOURCE_List;
5412:
5413: i NUMBER;