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 108: 'hz_parties party,'||

104: 'hz_cust_site_uses_all site_uses,'||
105: 'hz_cust_acct_sites_all acct_site,'||
106: 'hz_cust_accounts acct,'||
107: 'hz_party_sites party_site,'||
108: 'hz_parties party,'||
109: 'hz_locations loc ,'||
110: 'hz_Person_profiles person_profile '||
111: 'WHERE '||
112: ' site_uses.CUST_ACCT_SITE_ID = acct_site.CUST_ACCT_SITE_ID'||

Line 122: ' hz_Parties hp,' ||

118: ' AND party.PARTY_ID = person_profile.PARTY_ID(+) ';
119:
120: l_ContactQuery VARCHAR2(1000) := ' OR party.party_id IN' || --TCA view removal starts
121: '( SELECT hr.object_id FROM hz_relationships hr,' ||
122: ' hz_Parties hp,' ||
123: 'hz_contact_points hcp,' ||
124: ' hz_org_contacts hoc' ||
125: ' WHERE '||
126: ' hr.subject_table_name = ''HZ_PARTIES'' ' ||

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

122: ' hz_Parties hp,' ||
123: 'hz_contact_points hcp,' ||
124: ' hz_org_contacts hoc' ||
125: ' WHERE '||
126: ' hr.subject_table_name = ''HZ_PARTIES'' ' ||
127: ' AND hr.object_table_name =''HZ_PARTIES'' ' ||
128: ' AND hr.directional_flag = ''F'' ' ||
129: ' AND hr.relationship_type = ''CONTACT_OF'' '||
130: ' AND hr.subject_id = hp.party_id '||

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

123: 'hz_contact_points hcp,' ||
124: ' hz_org_contacts hoc' ||
125: ' WHERE '||
126: ' hr.subject_table_name = ''HZ_PARTIES'' ' ||
127: ' AND hr.object_table_name =''HZ_PARTIES'' ' ||
128: ' AND hr.directional_flag = ''F'' ' ||
129: ' AND hr.relationship_type = ''CONTACT_OF'' '||
130: ' AND hr.subject_id = hp.party_id '||
131: ' AND hcp.owner_table_id = hr.party_id '||

Line 211: 'hz_parties party,'||

207: 'PARTY.PROVINCE HZ_PROVINCE, '||
208: 'PARTY.COUNTY HZ_COUNTY '||
209: ' FROM '||
210: 'hz_party_sites party_site,'||
211: 'hz_parties party,'||
212: 'hz_locations loc ,'||
213: 'wsh_carriers_v wsh_car '||
214: 'WHERE '||
215: ' party_site.party_id = party.party_id'||

Line 297: 'hz_parties party,'||

293: 'PARTY.COUNTY HZ_COUNTY '||
294: ' FROM '||
295: 'hz_party_sites party_site,'||
296: 'hz_party_site_uses site_uses,'||
297: 'hz_parties party,'||
298: 'hz_locations loc, '||
299: 'hz_Person_profiles person_profile '||
300: 'WHERE '||
301: ' party_site.party_id (+) = party.party_id'||

Line 495: hz_parties HP,

491: CURSOR cur_customer_party_name(c_account_id varchar2) IS
492: SELECT
493: HP.party_name
494: FROM
495: hz_parties HP,
496: HZ_CUST_ACCOUNTS HC
497: WHERE
498: HP.PARTY_ID = HC.PARTY_ID AND
499: hc.cust_account_id = TO_NUMBER(c_account_id);

Line 508: HZ_PARTIES HP

504: SELECT
505: HP.PARTY_NAME
506: FROM
507: WSH_CARRIERS WC,
508: HZ_PARTIES HP
509: WHERE
510: HP.PARTY_ID = WC.CARRIER_ID AND
511: wc.freight_code = c_freight_code;
512:

Line 518: HZ_PARTIES HP

514: CURSOR cur_other_party_name(c_party_code varchar2) IS
515: SELECT
516: HP.PARTY_NAME
517: FROM
518: HZ_PARTIES HP
519: WHERE
520: HP.PARTY_ID = to_number(c_party_code);
521:
522: --

Line 1390: hz_Parties hp,

1386: l_ct_state_tab ,
1387: l_ct_province_tab ,
1388: l_ct_county_tab
1389: from hz_relationships hr, --TCA view removal Starts
1390: hz_Parties hp,
1391: hz_org_contacts hoc,
1392: hz_cust_account_roles hcar,
1393: hz_Person_profiles hpp
1394: where hr.subject_table_name = 'HZ_PARTIES'

Line 1394: where hr.subject_table_name = 'HZ_PARTIES'

1390: hz_Parties hp,
1391: hz_org_contacts hoc,
1392: hz_cust_account_roles hcar,
1393: hz_Person_profiles hpp
1394: where hr.subject_table_name = 'HZ_PARTIES'
1395: and hr.object_table_name = 'HZ_PARTIES'
1396: and hr.Directional_flag = 'F'
1397: and object_id = l_num_hzpartyID_tab(i)
1398: and hr.relationship_code = 'CONTACT_OF'

Line 1395: and hr.object_table_name = 'HZ_PARTIES'

1391: hz_org_contacts hoc,
1392: hz_cust_account_roles hcar,
1393: hz_Person_profiles hpp
1394: where hr.subject_table_name = 'HZ_PARTIES'
1395: and hr.object_table_name = 'HZ_PARTIES'
1396: and hr.Directional_flag = 'F'
1397: and object_id = l_num_hzpartyID_tab(i)
1398: and hr.relationship_code = 'CONTACT_OF'
1399: and hr.subject_id = hp.party_id

Line 1424: and owner_table_name = 'HZ_PARTIES'

1420: SELECT email_address into l_varchar_ctEmail_tab(j) FROM
1421: hz_contact_points where contact_point_type ='EMAIL'
1422: and owner_table_id = l_num_partyrel_tab(j)
1423: --added for bug 6391747
1424: and owner_table_name = 'HZ_PARTIES'
1425: and primary_flag ='Y';
1426: EXCEPTION
1427: WHEN NO_DATA_FOUND THEN
1428: l_varchar_ctEmail_tab(j) :=null;

Line 1436: AND owner_table_name = 'HZ_PARTIES'

1432: SELECT phone_number into l_varchar_ctPhone_tab(j) FROM
1433: hz_contact_points where contact_point_type ='PHONE'
1434: AND owner_table_id = l_num_partyrel_tab(j)
1435: --added for bug 6391747
1436: AND owner_table_name = 'HZ_PARTIES'
1437: AND phone_line_type= 'GEN'
1438: and primary_flag ='Y';
1439: EXCEPTION
1440: WHEN NO_DATA_FOUND THEN

Line 1448: AND owner_table_name = 'HZ_PARTIES'

1444: SELECT phone_number into l_varchar_ctFax_tab(j) FROM
1445: hz_contact_points where contact_point_type ='PHONE'
1446: AND owner_table_id = l_num_partyrel_tab(j)
1447: --added for bug 6391747
1448: AND owner_table_name = 'HZ_PARTIES'
1449: and phone_line_type= 'FAX'
1450: and primary_flag ='Y';
1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN