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.IMC_REPORTS_SUMMARY_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 120: -- HZ_CODE_ASSIGNMENTS table

116:
117: -- INSERT all the categories for ORGANIZATION
118:
119: -- fix bug 3296096, get CUSTOMER_CATEGORY from
120: -- HZ_CODE_ASSIGNMENTS table
121:
122: -- fix perf bug 3638775, here are the steps
123: -- Run sql statement twice is much faster than having outer join to HZ_PARTIES
124: -- 1) get all industry with customer_category

Line 140: FROM hz_parties pty, hz_code_assignments look, ar_lookups lkp

136: SELECT 'INDUSTRY','R',
137: industry, 'YES' industry_code, sum(org_count), sysdate
138: FROM (SELECT lkp.meaning industry,
139: decode(pty.party_type, 'ORGANIZATION', count(*), 0) org_count
140: FROM hz_parties pty, hz_code_assignments look, ar_lookups lkp
141: WHERE look.class_category = 'CUSTOMER_CATEGORY'
142: AND look.owner_table_name = 'HZ_PARTIES'
143: AND pty.party_id = look.owner_table_id
144: AND pty.party_type = 'ORGANIZATION'

Line 155: FROM hz_parties pty, hz_code_assignments look, ar_lookups lkp

151:
152: -- Step 2
153: SELECT count(1) INTO l_nd_ind
154: FROM (SELECT 1
155: FROM hz_parties pty, hz_code_assignments look, ar_lookups lkp
156: WHERE look.class_category = 'CUSTOMER_CATEGORY'
157: AND look.owner_table_name = 'HZ_PARTIES'
158: AND pty.party_id = look.owner_table_id
159: AND pty.party_type = 'ORGANIZATION'

Line 1328: , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt

1324: -- get contact count
1325: cursor get_cnt_count is
1326: SELECT count(1)
1327: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_PARTIES p
1328: , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt
1329: WHERE oc.party_relationship_id = r.relationship_id
1330: AND r.subject_type = 'PERSON'
1331: AND r.subject_id = p.party_id
1332: AND ca.class_category = 'RELATIONSHIP_TYPE_GROUP'

Line 1606: ELSIF(p_table_name = 'HZ_CODE_ASSIGNMENTS') THEN

1602: l_perf_hint := ' /*+ PARALLEL(rt) PARALLEL(ca) PARALLEL(pty) PARALLEL(r) PARALLEL(orgcnt) */ ';
1603: ELSIF(p_table_name = 'HZ_ORG_CONTACT_ROLES') THEN
1604: table_prefix := 'ocrole.';
1605: fromandwhere_str := get_org_contact_role_clause(p_table_name, p_party_type, p_attribute, p_system_date, x_return_status);
1606: ELSIF(p_table_name = 'HZ_CODE_ASSIGNMENTS') THEN
1607: table_prefix := 'ca.';
1608: fromandwhere_str := get_code_assign_clause(p_table_name, p_party_type, p_attribute, p_system_date, x_return_status);
1609: END IF;
1610:

Line 1628: IF((p_table_name = 'HZ_ORGANIZATION_PROFILES') OR (p_table_name = 'HZ_PERSON_PROFILES') OR (p_table_name = 'HZ_CODE_ASSIGNMENTS')) THEN

1624: ':p_date '||fromandwhere_str;
1625:
1626: write_log('>> sql string: '||str);
1627:
1628: IF((p_table_name = 'HZ_ORGANIZATION_PROFILES') OR (p_table_name = 'HZ_PERSON_PROFILES') OR (p_table_name = 'HZ_CODE_ASSIGNMENTS')) THEN
1629: execute immediate str using p_system_date, p_system_date, p_system_date;
1630: ELSE
1631: execute immediate str using p_system_date;
1632: END IF;

Line 2521: , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt

2517: -- count CONTACT
2518: cursor get_contact_count(l_date DATE) is
2519: SELECT count(1)
2520: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_PARTIES p
2521: , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt
2522: WHERE oc.party_relationship_id = r.relationship_id
2523: AND r.subject_type = 'PERSON'
2524: AND r.subject_id = p.party_id
2525: AND ca.class_category = 'RELATIONSHIP_TYPE_GROUP'

Line 2624: ' , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt'||

2620: BEGIN
2621:
2622: IF(p_party_type = 'CONTACT') THEN
2623: str := ' from HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_PARTIES pty'||
2624: ' , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt'||
2625: ' where pty.status in (''A'',''I'')'||
2626: ' and oc.party_relationship_id = r.relationship_id' ||
2627: ' and r.subject_type = ''PERSON'''||
2628: ' and r.party_id = pty.party_id'||

Line 2664: ' from HZ_CODE_ASSIGNMENTS c'||

2660: BEGIN
2661:
2662: -- code assignment is only for organization report
2663: str := ' from (select owner_table_id '||p_attribute||
2664: ' from HZ_CODE_ASSIGNMENTS c'||
2665: ' where owner_table_name = ''HZ_PARTIES'''||
2666: ' and status = ''A'''||
2667: ' and :p_date between c.start_date_active and nvl(c.end_date_active,:p_date)'||
2668: ' group by owner_table_id) ca';

Line 2736: ' HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt'||

2732:
2733: IF(p_party_type = 'CONTACT') THEN
2734: str := ' from HZ_PARTIES pty, HZ_CONTACT_POINTS contpt,'||
2735: ' HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r,'||
2736: ' HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt'||
2737: ' where pty.status in (''A'',''I'')'||
2738: ' and oc.party_relationship_id = r.relationship_id' ||
2739: ' and r.subject_type = ''PERSON'''||
2740: ' and r.party_id = pty.party_id'||

Line 2785: ' , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt'||

2781: BEGIN
2782:
2783: -- org_contact is only used for contact report
2784: str := ' from HZ_ORG_CONTACTS orgcnt, HZ_RELATIONSHIPS r, HZ_PARTIES pty'||
2785: ' , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt'||
2786: ' where pty.status in (''A'',''I'')'||
2787: ' and orgcnt.party_relationship_id = r.relationship_id' ||
2788: ' and r.subject_type = ''PERSON'''||
2789: ' and r.party_id = pty.party_id'||

Line 2820: ' , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt'||

2816: BEGIN
2817:
2818: str := ' from (select r.party_id '||p_attribute||
2819: ' from HZ_ORG_CONTACTS orgcnt, HZ_RELATIONSHIPS r, HZ_PARTIES pty'||
2820: ' , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt'||
2821: ' where pty.status in (''A'',''I'')'||
2822: ' and orgcnt.party_relationship_id = r.relationship_id' ||
2823: ' and r.subject_type = ''PERSON'''||
2824: ' and r.party_id = pty.party_id'||