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.AS_SALES_LEAD_CONTACTS_PVT dependencies on HZ_PARTIES

Line 44: HZ_PARTIES PARTY,

40: /*
41: CURSOR C_CONTACT_ID_Exists(c_contact_id NUMBER) IS
42: SELECT 'X'
43: FROM HZ_CONTACT_POINTS CONT_POINT,
44: HZ_PARTIES PARTY,
45: HZ_PARTIES PARTY2,
46: HZ_PARTY_RELATIONSHIPS REL,
47: HZ_ORG_CONTACTS ORG_CONT
48: WHERE ORG_CONT.PARTY_RELATIONSHIP_ID = REL.PARTY_RELATIONSHIP_ID

Line 45: HZ_PARTIES PARTY2,

41: CURSOR C_CONTACT_ID_Exists(c_contact_id NUMBER) IS
42: SELECT 'X'
43: FROM HZ_CONTACT_POINTS CONT_POINT,
44: HZ_PARTIES PARTY,
45: HZ_PARTIES PARTY2,
46: HZ_PARTY_RELATIONSHIPS REL,
47: HZ_ORG_CONTACTS ORG_CONT
48: WHERE ORG_CONT.PARTY_RELATIONSHIP_ID = REL.PARTY_RELATIONSHIP_ID
49: AND REL.OBJECT_ID = PARTY.PARTY_ID

Line 51: AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

47: HZ_ORG_CONTACTS ORG_CONT
48: WHERE ORG_CONT.PARTY_RELATIONSHIP_ID = REL.PARTY_RELATIONSHIP_ID
49: AND REL.OBJECT_ID = PARTY.PARTY_ID
50: AND REL.PARTY_ID = PARTY2.PARTY_ID
51: AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
52: AND CONT_POINT.OWNER_TABLE_ID(+) = PARTY.PARTY_ID
53: AND CONT_POINT.CONTACT_POINT_TYPE(+) = 'EMAIL'
54: AND ORG_CONT.ORG_CONTACT_ID = c_contact_id
55: AND PARTY.PARTY_ID = P_CUSTOMER_ID;

Line 63: HZ_PARTIES PARTY,

59: -- HZ_PARTY_RELATIONSHIPS
60: CURSOR C_CONTACT_ID_Exists(c_contact_id NUMBER) IS
61: SELECT 'X'
62: FROM -- HZ_CONTACT_POINTS CONT_POINT,
63: HZ_PARTIES PARTY,
64: HZ_PARTIES PARTY2,
65: HZ_RELATIONSHIPS REL,
66: HZ_ORG_CONTACTS ORG_CONT
67: WHERE ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID

Line 64: HZ_PARTIES PARTY2,

60: CURSOR C_CONTACT_ID_Exists(c_contact_id NUMBER) IS
61: SELECT 'X'
62: FROM -- HZ_CONTACT_POINTS CONT_POINT,
63: HZ_PARTIES PARTY,
64: HZ_PARTIES PARTY2,
65: HZ_RELATIONSHIPS REL,
66: HZ_ORG_CONTACTS ORG_CONT
67: WHERE ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
68: AND REL.OBJECT_ID = PARTY.PARTY_ID AND REL.PARTY_ID = PARTY2.PARTY_ID

Line 69: -- AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

65: HZ_RELATIONSHIPS REL,
66: HZ_ORG_CONTACTS ORG_CONT
67: WHERE ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
68: AND REL.OBJECT_ID = PARTY.PARTY_ID AND REL.PARTY_ID = PARTY2.PARTY_ID
69: -- AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
70: -- AND CONT_POINT.OWNER_TABLE_ID(+) = PARTY.PARTY_ID
71: -- AND CONT_POINT.CONTACT_POINT_TYPE(+) = 'EMAIL'
72: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
73: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 72: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

68: AND REL.OBJECT_ID = PARTY.PARTY_ID AND REL.PARTY_ID = PARTY2.PARTY_ID
69: -- AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
70: -- AND CONT_POINT.OWNER_TABLE_ID(+) = PARTY.PARTY_ID
71: -- AND CONT_POINT.CONTACT_POINT_TYPE(+) = 'EMAIL'
72: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
73: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
74: AND ORG_CONT.ORG_CONTACT_ID = c_contact_id
75: AND PARTY.PARTY_ID = P_CUSTOMER_ID --;
76: -- ffang 100901, bug 2039435, add checking on status

Line 73: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

69: -- AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
70: -- AND CONT_POINT.OWNER_TABLE_ID(+) = PARTY.PARTY_ID
71: -- AND CONT_POINT.CONTACT_POINT_TYPE(+) = 'EMAIL'
72: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
73: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
74: AND ORG_CONT.ORG_CONTACT_ID = c_contact_id
75: AND PARTY.PARTY_ID = P_CUSTOMER_ID --;
76: -- ffang 100901, bug 2039435, add checking on status
77: AND PARTY.STATUS IN ('A', 'I');

Line 146: and subject_table_name = 'HZ_PARTIES'

142: Select 'X'
143: from hz_relationships
144: where party_id = c_CONTACT_PARTY_ID
145: and object_id = P_CUSTOMER_ID
146: and subject_table_name = 'HZ_PARTIES'
147: and object_table_name = 'HZ_PARTIES' --;
148: --and relationship_code = 'CONTACT_OF';
149: -- ffang 100901, bug 2039435, add checking on status
150: AND STATUS IN ('A', 'I');

Line 147: and object_table_name = 'HZ_PARTIES' --;

143: from hz_relationships
144: where party_id = c_CONTACT_PARTY_ID
145: and object_id = P_CUSTOMER_ID
146: and subject_table_name = 'HZ_PARTIES'
147: and object_table_name = 'HZ_PARTIES' --;
148: --and relationship_code = 'CONTACT_OF';
149: -- ffang 100901, bug 2039435, add checking on status
150: AND STATUS IN ('A', 'I');
151:

Line 260: AND owner_table_name = 'HZ_PARTIES'

256: CURSOR C_PHONE_ID_Exists(c_phone_id NUMBER) IS
257: SELECT 'X'
258: FROM HZ_CONTACT_POINTS
259: WHERE contact_point_id = c_phone_id
260: AND owner_table_name = 'HZ_PARTIES'
261: AND owner_table_id = P_CONTACT_PARTY_ID
262: AND CONTACT_POINT_TYPE IN ( 'PHONE', 'FAX') --;
263: -- ffang 100901, bug 2039435, add checking on status
264: AND STATUS IN ('A', 'I');