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.CSM_PARTY_DATA_EVENT_PKG dependencies on HZ_CONTACT_POINTS

Line 30: g_acc_table_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC';

26: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
27: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
28: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
29:
30: g_acc_table_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC';
31: g_acc_sequence_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC_S';
32: g_pk1_name4 CONSTANT VARCHAR2(30) := 'CONTACT_POINT_ID';
33: g_publication_item_name4 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
34: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CONTACT_POINTS');

Line 31: g_acc_sequence_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC_S';

27: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
28: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
29:
30: g_acc_table_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC';
31: g_acc_sequence_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC_S';
32: g_pk1_name4 CONSTANT VARCHAR2(30) := 'CONTACT_POINT_ID';
33: g_publication_item_name4 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
34: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CONTACT_POINTS');
35:

Line 34: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CONTACT_POINTS');

30: g_acc_table_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC';
31: g_acc_sequence_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC_S';
32: g_pk1_name4 CONSTANT VARCHAR2(30) := 'CONTACT_POINT_ID';
33: g_publication_item_name4 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
34: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CONTACT_POINTS');
35:
36: /*g_acc_table_name5 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC';
37: g_acc_sequence_name5 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC_S';
38: g_pk1_name5 CONSTANT VARCHAR2(30) := 'PARTY_ID';

Line 340: , hz_contact_points hcp

336: , hpr.directional_flag
337: , hpr.subject_id
338: FROM hz_relationships hpr
339: , csm_party_assignment tcpa
340: , hz_contact_points hcp
341: WHERE hpr.object_id = tcpa.party_id
342: AND hpr.party_id = hcp.owner_table_id
343: AND hpr.relationship_code IN ('CONTACT_OF','EMPLOYEE_OF')
344: AND hcp.primary_flag = 'Y'

Line 545: , hz_contact_points hcp

541: , hpr.directional_flag
542: , hpr.subject_id
543: FROM hz_relationships hpr
544: , csm_party_assignment tcpa
545: , hz_contact_points hcp
546: WHERE hpr.object_id = tcpa.party_id
547: AND hpr.party_id = hcp.owner_table_id
548: AND hpr.relationship_code IN ('CONTACT_OF','EMPLOYEE_OF')
549: AND hcp.primary_flag = 'Y'