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_RELATIONSHIPS

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 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 2730: -- if the reports is used for contact, then we need to use HZ_RELATIONSHIPS

2726: ELSE
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,'||

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