APPS.IMC_REPORTS_SUMMARY_PKG dependencies on HZ_ORG_CONTACTS

Line 1327: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_PARTIES p

1323:
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

Line 1598: ELSIF(p_table_name = 'HZ_ORG_CONTACTS') THEN

1594: l_perf_hint := ' /*+ PARALLEL(rt) PARALLEL(ca) PARALLEL(r) PARALLEL(oc) PARALLEL(contpt) PARALLEL(pty) */ ';
1595: ELSE
1596: l_perf_hint := ' /*+ PARALLEL(contpt) PARALLEL(pty) */ ';
1597: END IF;
1598: ELSIF(p_table_name = 'HZ_ORG_CONTACTS') THEN
1599: table_prefix := 'orgcnt.';
1600: fromandwhere_str := get_org_contact_clause(p_table_name, p_party_type, p_system_date, x_return_status);
1601: -- Perf Bug 6322629 (Add parallel hint for contact tables as volume of data is too high)
1602: l_perf_hint := ' /*+ PARALLEL(rt) PARALLEL(ca) PARALLEL(pty) PARALLEL(r) PARALLEL(orgcnt) */ ';

Line 2508: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_PARTIES p

2504:
2505: -- count CONTACT
2506: cursor get_contact_count(l_date DATE) is
2507: SELECT count(1)
2508: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_PARTIES p
2509: , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt
2510: WHERE oc.party_relationship_id = r.relationship_id
2511: AND r.subject_type = 'PERSON'
2512: AND r.subject_id = p.party_id

Line 2611: str := ' from HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_PARTIES pty'||

2607:
2608: BEGIN
2609:
2610: IF(p_party_type = 'CONTACT') THEN
2611: str := ' from HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_PARTIES pty'||
2612: ' , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt'||
2613: ' where pty.status in (''A'',''I'')'||
2614: ' and oc.party_relationship_id = r.relationship_id' ||
2615: ' and r.subject_type = ''PERSON'''||

Line 2719: -- and HZ_ORG_CONTACTS table to find out that person

2715: l_contact_point_type := 'PHONE';
2716: END IF;
2717:
2718: -- if the reports is used for contact, then we need to use HZ_RELATIONSHIPS
2719: -- and HZ_ORG_CONTACTS table to find out that person
2720:
2721: IF(p_party_type = 'CONTACT') THEN
2722: str := ' from HZ_PARTIES pty, HZ_CONTACT_POINTS contpt,'||
2723: ' HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r,'||

Line 2723: ' HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r,'||

2719: -- and HZ_ORG_CONTACTS table to find out that person
2720:
2721: IF(p_party_type = 'CONTACT') THEN
2722: str := ' from HZ_PARTIES pty, HZ_CONTACT_POINTS contpt,'||
2723: ' HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r,'||
2724: ' HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt'||
2725: ' where pty.status in (''A'',''I'')'||
2726: ' and oc.party_relationship_id = r.relationship_id' ||
2727: ' and r.subject_type = ''PERSON'''||

Line 2772: str := ' from HZ_ORG_CONTACTS orgcnt, HZ_RELATIONSHIPS r, HZ_PARTIES pty'||

2768:
2769: BEGIN
2770:
2771: -- org_contact is only used for contact report
2772: str := ' from HZ_ORG_CONTACTS orgcnt, HZ_RELATIONSHIPS r, HZ_PARTIES pty'||
2773: ' , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt'||
2774: ' where pty.status in (''A'',''I'')'||
2775: ' and orgcnt.party_relationship_id = r.relationship_id' ||
2776: ' and r.subject_type = ''PERSON'''||

Line 2807: ' from HZ_ORG_CONTACTS orgcnt, HZ_RELATIONSHIPS r, HZ_PARTIES pty'||

2803:
2804: BEGIN
2805:
2806: str := ' from (select r.party_id '||p_attribute||
2807: ' from HZ_ORG_CONTACTS orgcnt, HZ_RELATIONSHIPS r, HZ_PARTIES pty'||
2808: ' , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt'||
2809: ' where pty.status in (''A'',''I'')'||
2810: ' and orgcnt.party_relationship_id = r.relationship_id' ||
2811: ' and r.subject_type = ''PERSON'''||