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

Line 88: 'hz_parties party,'||

84: 'hz_cust_site_uses_all site_uses,'||
85: 'hz_cust_acct_sites_all acct_site,'||
86: 'hz_cust_accounts acct,'||
87: 'hz_party_sites party_site,'||
88: 'hz_parties party,'||
89: 'hz_locations loc ,'||
90: 'hz_Person_profiles person_profile '||
91: 'WHERE '||
92: ' site_uses.CUST_ACCT_SITE_ID = acct_site.CUST_ACCT_SITE_ID'||

Line 102: ' hz_Parties hp,' ||

98: ' AND party.PARTY_ID = person_profile.PARTY_ID(+) ';
99:
100: l_ContactQuery VARCHAR2(1000) := ' OR party.party_id IN' || --TCA view removal starts
101: '( SELECT hr.object_id FROM hz_relationships hr,' ||
102: ' hz_Parties hp,' ||
103: 'hz_contact_points hcp,' ||
104: ' hz_org_contacts hoc' ||
105: ' WHERE '||
106: ' hr.subject_table_name = ''HZ_PARTIES'' ' ||

Line 106: ' hr.subject_table_name = ''HZ_PARTIES'' ' ||

102: ' hz_Parties hp,' ||
103: 'hz_contact_points hcp,' ||
104: ' hz_org_contacts hoc' ||
105: ' WHERE '||
106: ' hr.subject_table_name = ''HZ_PARTIES'' ' ||
107: ' AND hr.object_table_name =''HZ_PARTIES'' ' ||
108: ' AND hr.directional_flag = ''F'' ' ||
109: ' AND hr.relationship_type = ''CONTACT_OF'' '||
110: ' AND hr.subject_id = hp.party_id '||

Line 107: ' AND hr.object_table_name =''HZ_PARTIES'' ' ||

103: 'hz_contact_points hcp,' ||
104: ' hz_org_contacts hoc' ||
105: ' WHERE '||
106: ' hr.subject_table_name = ''HZ_PARTIES'' ' ||
107: ' AND hr.object_table_name =''HZ_PARTIES'' ' ||
108: ' AND hr.directional_flag = ''F'' ' ||
109: ' AND hr.relationship_type = ''CONTACT_OF'' '||
110: ' AND hr.subject_id = hp.party_id '||
111: ' AND hcp.owner_table_id = hr.party_id '||

Line 171: 'hz_parties party,'||

167: ' null, ' ||
168: 'party_site.identifying_address_flag address_type ' ||
169: ' FROM '||
170: 'hz_party_sites party_site,'||
171: 'hz_parties party,'||
172: 'hz_locations loc ,'||
173: 'wsh_carriers_v wsh_car '||
174: 'WHERE '||
175: ' party_site.party_id = party.party_id'||

Line 316: hz_parties HP,

312: CURSOR cur_customer_party_name(c_account_id varchar2) IS
313: SELECT
314: HP.party_name
315: FROM
316: hz_parties HP,
317: HZ_CUST_ACCOUNTS HC
318: WHERE
319: HP.PARTY_ID = HC.PARTY_ID AND
320: hc.cust_account_id = TO_NUMBER(c_account_id);

Line 329: HZ_PARTIES HP

325: SELECT
326: HP.PARTY_NAME
327: FROM
328: WSH_CARRIERS WC,
329: HZ_PARTIES HP
330: WHERE
331: HP.PARTY_ID = WC.CARRIER_ID AND
332: wc.freight_code = c_freight_code;
333:

Line 1013: hz_Parties hp,

1009: l_varchar_Attrib13_tab,
1010: l_varchar_Attrib14_tab,
1011: l_varchar_Attrib15_tab
1012: from hz_relationships hr, --TCA view removal Starts
1013: hz_Parties hp,
1014: hz_org_contacts hoc,
1015: hz_cust_account_roles hcar
1016: where hr.subject_table_name = 'HZ_PARTIES'
1017: and hr.object_table_name = 'HZ_PARTIES'

Line 1016: where hr.subject_table_name = 'HZ_PARTIES'

1012: from hz_relationships hr, --TCA view removal Starts
1013: hz_Parties hp,
1014: hz_org_contacts hoc,
1015: hz_cust_account_roles hcar
1016: where hr.subject_table_name = 'HZ_PARTIES'
1017: and hr.object_table_name = 'HZ_PARTIES'
1018: and hr.Directional_flag = 'F'
1019: and object_id = l_num_hzpartyID_tab(i)
1020: and hr.relationship_code = 'CONTACT_OF'

Line 1017: and hr.object_table_name = 'HZ_PARTIES'

1013: hz_Parties hp,
1014: hz_org_contacts hoc,
1015: hz_cust_account_roles hcar
1016: where hr.subject_table_name = 'HZ_PARTIES'
1017: and hr.object_table_name = 'HZ_PARTIES'
1018: and hr.Directional_flag = 'F'
1019: and object_id = l_num_hzpartyID_tab(i)
1020: and hr.relationship_code = 'CONTACT_OF'
1021: and hr.subject_id = hp.party_id

Line 1043: and owner_table_name = 'HZ_PARTIES'

1039: SELECT email_address into l_varchar_ctEmail_tab(j) FROM
1040: hz_contact_points where contact_point_type ='EMAIL'
1041: and owner_table_id = l_num_partyrel_tab(j)
1042: --added for bug 6391747
1043: and owner_table_name = 'HZ_PARTIES'
1044: and primary_flag ='Y';
1045: EXCEPTION
1046: WHEN NO_DATA_FOUND THEN
1047: l_varchar_ctEmail_tab(j) :=null;

Line 1055: AND owner_table_name = 'HZ_PARTIES'

1051: SELECT phone_number into l_varchar_ctPhone_tab(j) FROM
1052: hz_contact_points where contact_point_type ='PHONE'
1053: AND owner_table_id = l_num_partyrel_tab(j)
1054: --added for bug 6391747
1055: AND owner_table_name = 'HZ_PARTIES'
1056: AND phone_line_type= 'GEN'
1057: and primary_flag ='Y';
1058: EXCEPTION
1059: WHEN NO_DATA_FOUND THEN

Line 1067: AND owner_table_name = 'HZ_PARTIES'

1063: SELECT phone_number into l_varchar_ctFax_tab(j) FROM
1064: hz_contact_points where contact_point_type ='PHONE'
1065: AND owner_table_id = l_num_partyrel_tab(j)
1066: --added for bug 6391747
1067: AND owner_table_name = 'HZ_PARTIES'
1068: and phone_line_type= 'FAX'
1069: and primary_flag ='Y';
1070: EXCEPTION
1071: WHEN NO_DATA_FOUND THEN