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_RELATIONSHIP_TYPES

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 1333: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

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'
1333: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
1334: AND ca.class_code = 'PARTY_REL_GRP_CONTACTS'
1335: AND rt.relationship_type_id = ca.owner_table_id
1336: AND rt.subject_type = 'PERSON'
1337: AND rt.forward_rel_code = r.relationship_code

Line 2509: , HZ_CODE_ASSIGNMENTS ca, HZ_RELATIONSHIP_TYPES rt

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
2513: AND ca.class_category = 'RELATIONSHIP_TYPE_GROUP'

Line 2514: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

2510: WHERE oc.party_relationship_id = r.relationship_id
2511: AND r.subject_type = 'PERSON'
2512: AND r.subject_id = p.party_id
2513: AND ca.class_category = 'RELATIONSHIP_TYPE_GROUP'
2514: AND ca.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
2515: AND ca.class_code = 'PARTY_REL_GRP_CONTACTS'
2516: AND rt.relationship_type_id = ca.owner_table_id
2517: AND rt.subject_type = 'PERSON'
2518: AND rt.forward_rel_code = r.relationship_code

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

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'''||
2616: ' and r.party_id = pty.party_id'||

Line 2618: ' and ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES'''||

2614: ' and oc.party_relationship_id = r.relationship_id' ||
2615: ' and r.subject_type = ''PERSON'''||
2616: ' and r.party_id = pty.party_id'||
2617: ' and ca.class_category = ''RELATIONSHIP_TYPE_GROUP'''||
2618: ' and ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES'''||
2619: ' and ca.class_code = ''PARTY_REL_GRP_CONTACTS'''||
2620: ' and rt.relationship_type_id = ca.owner_table_id'||
2621: ' and rt.subject_type = ''PERSON'''||
2622: ' and rt.forward_rel_code = r.relationship_code'||

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

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'''||
2728: ' and r.party_id = pty.party_id'||

Line 2730: ' and ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES'''||

2726: ' and oc.party_relationship_id = r.relationship_id' ||
2727: ' and r.subject_type = ''PERSON'''||
2728: ' and r.party_id = pty.party_id'||
2729: ' and ca.class_category = ''RELATIONSHIP_TYPE_GROUP'''||
2730: ' and ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES'''||
2731: ' and ca.class_code = ''PARTY_REL_GRP_CONTACTS'''||
2732: ' and rt.relationship_type_id = ca.owner_table_id'||
2733: ' and rt.subject_type = ''PERSON'''||
2734: ' and rt.forward_rel_code = r.relationship_code'||

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

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'''||
2777: ' and r.party_id = pty.party_id'||

Line 2779: ' and ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES'''||

2775: ' and orgcnt.party_relationship_id = r.relationship_id' ||
2776: ' and r.subject_type = ''PERSON'''||
2777: ' and r.party_id = pty.party_id'||
2778: ' and ca.class_category = ''RELATIONSHIP_TYPE_GROUP'''||
2779: ' and ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES'''||
2780: ' and ca.class_code = ''PARTY_REL_GRP_CONTACTS'''||
2781: ' and rt.relationship_type_id = ca.owner_table_id'||
2782: ' and rt.subject_type = ''PERSON'''||
2783: ' and rt.forward_rel_code = r.relationship_code'||

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

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'''||
2812: ' and r.party_id = pty.party_id'||

Line 2814: ' and ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES'''||

2810: ' and orgcnt.party_relationship_id = r.relationship_id' ||
2811: ' and r.subject_type = ''PERSON'''||
2812: ' and r.party_id = pty.party_id'||
2813: ' and ca.class_category = ''RELATIONSHIP_TYPE_GROUP'''||
2814: ' and ca.owner_table_name = ''HZ_RELATIONSHIP_TYPES'''||
2815: ' and ca.class_code = ''PARTY_REL_GRP_CONTACTS'''||
2816: ' and rt.relationship_type_id = ca.owner_table_id'||
2817: ' and rt.subject_type = ''PERSON'''||
2818: ' and rt.forward_rel_code = r.relationship_code'||