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 2520: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_PARTIES p

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

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

2619:
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'''||

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

2727: l_contact_point_type := 'PHONE';
2728: END IF;
2729:
2730: -- if the reports is used for contact, then we need to use HZ_RELATIONSHIPS
2731: -- and HZ_ORG_CONTACTS table to find out that person
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,'||

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

2731: -- and HZ_ORG_CONTACTS table to find out that person
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'''||

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

2780:
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'''||

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

2815:
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'''||