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.

[Home] [Help]

APPS.HZ_MIXNM_UTILITY dependencies on HZ_SELECT_DATA_SOURCES

Line 356: hz_select_data_sources s

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

Line 395: hz_select_data_sources s1,

391: SELECT e.entity_attr_id,
392: NVL(exp.content_source_type, s1.content_source_type),
393: exp.exception_type
394: FROM hz_entity_attributes e,
395: hz_select_data_sources s1,
396: (SELECT entity_attr_id,
397: content_source_type,
398: exception_type
399: FROM hz_win_source_exceps

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

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

Line 917: hz_select_data_sources s

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

Line 930: hz_select_data_sources s

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

Line 2533: FROM hz_select_data_sources

2529: SYSDATE,
2530: hz_utility_v2pub.last_update_login,
2531: SYSDATE,
2532: hz_utility_v2pub.last_updated_by
2533: FROM hz_select_data_sources
2534: WHERE ranking > 0
2535: and content_source_type = 'USER_ENTERED'
2536: and entity_attr_id = i_entity_attr_id(i)
2537: and i_exception_type(i) <> 'MRN';

Line 2834: FROM hz_select_data_sources

2830: SYSDATE,
2831: hz_utility_v2pub.last_update_login,
2832: SYSDATE,
2833: hz_utility_v2pub.last_updated_by
2834: FROM hz_select_data_sources
2835: WHERE ranking > 1
2836: and content_source_type = 'USER_ENTERED'
2837: and entity_attr_id = l_entity_attr_id;
2838: ELSE

Line 3707: from hz_select_data_sources d, hz_entity_attributes e

3703: -- check if policy exists.
3704: -- bug fix 2731008
3705: BEGIN
3706: select 'Y' into l_src_selected
3707: from hz_select_data_sources d, hz_entity_attributes e
3708: where e.entity_attr_id = d.entity_attr_id
3709: and UPPER(e.entity_name) = UPPER(p_entity_name)
3710: and d.content_source_type <> G_MISS_CONTENT_SOURCE_TYPE
3711: and d.ranking > 0

Line 5052: hz_select_data_sources s

5048:
5049: CURSOR c_other_setup IS
5050: SELECT 'Y'
5051: FROM hz_entity_attributes e,
5052: hz_select_data_sources s
5053: WHERE e.updated_flag = 'Y'
5054: AND e.entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
5055: AND rownum = 1;
5056:

Line 5146: FROM hz_entity_attributes e, hz_select_data_sources s

5142: IF l_process_org AND l_org_total <> 0 THEN
5143: DELETE hz_win_source_exceps
5144: WHERE entity_attr_id IN
5145: (SELECT e.entity_attr_id
5146: FROM hz_entity_attributes e, hz_select_data_sources s
5147: WHERE e.entity_name = 'HZ_ORGANIZATION_PROFILES'
5148: AND s.ranking > 0
5149: AND s.content_source_type = 'USER_ENTERED'
5150: AND e.entity_attr_id = s.entity_attr_id

Line 5158: FROM hz_entity_attributes e, hz_select_data_sources s

5154: IF l_process_person AND l_per_total <> 0 THEN
5155: DELETE hz_win_source_exceps
5156: WHERE entity_attr_id IN
5157: (SELECT e.entity_attr_id
5158: FROM hz_entity_attributes e, hz_select_data_sources s
5159: WHERE e.entity_name = 'HZ_PERSON_PROFILES'
5160: AND s.ranking > 0
5161: AND s.content_source_type = 'USER_ENTERED'
5162: AND e.entity_attr_id = s.entity_attr_id

Line 5363: from hz_entity_attributes e, hz_select_data_sources s

5359: )IS
5360:
5361: cursor mmr_attributes IS
5362: select e.entity_attr_id, s.content_source_type
5363: from hz_entity_attributes e, hz_select_data_sources s
5364: where s.ranking = -1
5365: AND e.entity_name = p_entity_name
5366: AND e.entity_attr_id = s.entity_attr_id
5367: AND (s.content_source_type= p_data_source_type or

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

5365: AND e.entity_name = p_entity_name
5366: AND e.entity_attr_id = s.entity_attr_id
5367: AND (s.content_source_type= p_data_source_type or
5368: (s.content_source_type='USER_ENTERED' AND
5369: NOT EXISTS(select 'Y' from hz_select_data_sources s1
5370: where s1.ranking = -1 and s1.content_source_type = p_data_source_type
5371: and s1.entity_attr_id = e.entity_attr_id)))
5372: -- Bug 4244112 : populate only if does not exist
5373: AND NOT EXISTS(select 'Y' from hz_win_source_exceps

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

5374: where party_id = p_party_id
5375: and entity_attr_id = e.entity_attr_id);
5376:
5377: TYPE ATTR_IDList IS TABLE OF hz_entity_attributes.entity_attr_id%TYPE;
5378: TYPE SOURCE_List IS TABLE OF hz_select_data_sources.content_source_type%TYPE;
5379: I_ATTR_ID ATTR_IDList;
5380: I_SOURCE SOURCE_List;
5381:
5382: i NUMBER;