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_MAPPING_DATA dependencies on HZ_CUST_ACCT_SITES_ALL

Line 133: HZ_CUST_ACCT_SITES_ALL HCAS,

129: p_ship_to_location_id IN NUMBER,
130: p_org_id IN NUMBER) is
131: SELECT HCSU.LOCATION, HCSU.CONTACT_ID
132: FROM HZ_CUST_SITE_USES_ALL HCSU,
133: HZ_CUST_ACCT_SITES_ALL HCAS,
134: HZ_CUST_ACCOUNTS HCA,
135: HZ_PARTY_SITES HPS
136: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
137: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID

Line 155: HZ_CUST_ACCT_SITES_ALL HCAS,

151: p_ship_to_location_id IN NUMBER,
152: p_org_id IN NUMBER) is
153: SELECT HCSU.LOCATION, HCSU.CONTACT_ID
154: FROM HZ_CUST_SITE_USES_ALL HCSU,
155: HZ_CUST_ACCT_SITES_ALL HCAS,
156: HZ_PARTY_SITES HPS,
157: HZ_CUST_ACCOUNTS HCA,
158: HZ_CUST_ACCT_RELATE_ALL HCAR
159: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID

Line 842: HZ_CUST_ACCT_SITES_ALL HCAS,

838: CURSOR loc_cust_cur (p_loc_id NUMBER, p_org_id NUMBER, p_cust_id NUMBER) IS
839: SELECT HCSU.LOCATION --bug 3920178 , HP.PARTY_NAME, HP.PARTY_NUMBER
840: FROM
841: HZ_CUST_SITE_USES_ALL HCSU,
842: HZ_CUST_ACCT_SITES_ALL HCAS,
843: HZ_PARTY_SITES HPS,
844: HZ_CUST_ACCOUNTS HCA,
845: HZ_PARTIES HP,
846: WSH_LOCATIONS WL1

Line 902: HZ_CUST_ACCT_SITES_ALL HCAS,

898: p_ship_to_location_id IN NUMBER,
899: p_org_id IN NUMBER) is
900: SELECT HCSU.LOCATION
901: FROM HZ_CUST_SITE_USES_ALL HCSU,
902: HZ_CUST_ACCT_SITES_ALL HCAS,
903: HZ_PARTY_SITES HPS,
904: HZ_CUST_ACCOUNTS HCA,
905: HZ_CUST_ACCT_RELATE_ALL HCAR
906: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID

Line 1399: hz_cust_acct_sites_all hcas,

1395: c_ship_to_location_id IN NUMBER,
1396: c_org_id IN NUMBER) IS
1397: SELECT hcsu.location
1398: FROM hz_cust_site_uses_all hcsu,
1399: hz_cust_acct_sites_all hcas,
1400: hz_cust_accounts hca,
1401: hz_party_sites hps
1402: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
1403: AND hcas.party_site_id = hps.party_site_id

Line 1420: hz_cust_acct_sites_all hcas,

1416: c_ship_to_location_id IN NUMBER,
1417: c_org_id IN NUMBER) IS
1418: SELECT hcsu.location
1419: FROM hz_cust_site_uses_all hcsu,
1420: hz_cust_acct_sites_all hcas,
1421: hz_party_sites hps,
1422: hz_cust_accounts hca,
1423: hz_cust_acct_relate_all hcar
1424: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id