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

Line 55: AND CONTACT.subject_table_name = 'HZ_PARTIES'

51: jtf_rs_resource_extns EXTN
52: WHERE EXTN.resource_id = pc_salesforce_id
53: AND EXTN.source_id = CONTACT.party_id
54: AND EXTN.category = 'PARTY'
55: AND CONTACT.subject_table_name = 'HZ_PARTIES'
56: AND CONTACT.object_table_name = 'HZ_PARTIES'
57: AND CONTACT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
58: AND CONTACT.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
59: AND CONTACT.directional_flag = 'F'

Line 56: AND CONTACT.object_table_name = 'HZ_PARTIES'

52: WHERE EXTN.resource_id = pc_salesforce_id
53: AND EXTN.source_id = CONTACT.party_id
54: AND EXTN.category = 'PARTY'
55: AND CONTACT.subject_table_name = 'HZ_PARTIES'
56: AND CONTACT.object_table_name = 'HZ_PARTIES'
57: AND CONTACT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
58: AND CONTACT.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
59: AND CONTACT.directional_flag = 'F'
60: AND CONTACT.STATUS = 'A'

Line 64: AND PTORG.subject_table_name = 'HZ_PARTIES'

60: AND CONTACT.STATUS = 'A'
61: AND CONTACT.start_date <= SYSDATE
62: AND nvl(CONTACT.end_date, SYSDATE) >= SYSDATE
63: AND PTORG.subject_id = CONTACT.object_id
64: AND PTORG.subject_table_name = 'HZ_PARTIES'
65: AND PTORG.object_table_name = 'HZ_PARTIES'
66: AND PTORG.RELATIONSHIP_TYPE = 'PARTNER'
67: AND PTORG.STATUS = 'A'
68: AND PTORG.start_date <= SYSDATE

Line 65: AND PTORG.object_table_name = 'HZ_PARTIES'

61: AND CONTACT.start_date <= SYSDATE
62: AND nvl(CONTACT.end_date, SYSDATE) >= SYSDATE
63: AND PTORG.subject_id = CONTACT.object_id
64: AND PTORG.subject_table_name = 'HZ_PARTIES'
65: AND PTORG.object_table_name = 'HZ_PARTIES'
66: AND PTORG.RELATIONSHIP_TYPE = 'PARTNER'
67: AND PTORG.STATUS = 'A'
68: AND PTORG.start_date <= SYSDATE
69: AND nvl(PTORG.end_date, SYSDATE) >= SYSDATE

Line 87: 1 from as_accesses_all acc , hz_relationships hzpp , hz_parties ptorg,

83:
84: CURSOR lc_get_upd_del_check_perm(pc_lead_id number, pc_access_id number) is
85:
86: SELECT
87: 1 from as_accesses_all acc , hz_relationships hzpp , hz_parties ptorg,
88: fnd_user fndu, jtf_rs_resource_extns jtfre,
89: hz_parties ptorg1 ,hz_relationships hzpp1
90: WHERE
91: acc.partner_cont_party_id = hzpp.party_id and

Line 89: hz_parties ptorg1 ,hz_relationships hzpp1

85:
86: SELECT
87: 1 from as_accesses_all acc , hz_relationships hzpp , hz_parties ptorg,
88: fnd_user fndu, jtf_rs_resource_extns jtfre,
89: hz_parties ptorg1 ,hz_relationships hzpp1
90: WHERE
91: acc.partner_cont_party_id = hzpp.party_id and
92: hzpp.object_id = ptorg.party_id and
93: ptorg.party_type = 'ORGANIZATION' and

Line 116: AND CONTACT.subject_table_name = 'HZ_PARTIES'

112: fnd_user fndu
113: WHERE fndu.user_id = fnd_global.user_id
114: AND EXTN.user_id = fndu.user_id
115: AND CONTACT.party_id = EXTN.source_id
116: AND CONTACT.subject_table_name = 'HZ_PARTIES'
117: AND CONTACT.object_table_name = 'HZ_PARTIES'
118: AND CONTACT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
119: AND CONTACT.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
120: AND CONTACT.directional_flag = 'F'

Line 117: AND CONTACT.object_table_name = 'HZ_PARTIES'

113: WHERE fndu.user_id = fnd_global.user_id
114: AND EXTN.user_id = fndu.user_id
115: AND CONTACT.party_id = EXTN.source_id
116: AND CONTACT.subject_table_name = 'HZ_PARTIES'
117: AND CONTACT.object_table_name = 'HZ_PARTIES'
118: AND CONTACT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
119: AND CONTACT.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
120: AND CONTACT.directional_flag = 'F'
121: AND CONTACT.STATUS = 'A'