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_WSHRDPAK_XMLP_PKG dependencies on HZ_LOCATIONS

Line 1178: HZ_LOCATIONS LOC

1174: FROM
1175: WSH_ORG_CARRIER_SITES ORG_SITES,
1176: WSH_NEW_DELIVERIES DEL,
1177: HZ_PARTY_SITES HZ_SITES,
1178: HZ_LOCATIONS LOC
1179: WHERE ORG_SITES.ORGANIZATION_ID = DEL.ORGANIZATION_ID
1180: AND HZ_SITES.PARTY_SITE_ID = ORG_SITES.CARRIER_SITE_ID
1181: AND HZ_SITES.PARTY_ID = C_CARRIER_ID
1182: AND ORG_SITES.ENABLED_FLAG = 'Y'

Line 1206: HZ_LOCATIONS LOC

1202: FROM
1203: WSH_ORG_CARRIER_SITES ORG_SITES,
1204: WSH_NEW_DELIVERIES DEL,
1205: HZ_PARTY_SITES HZ_SITES,
1206: HZ_LOCATIONS LOC
1207: WHERE ORG_SITES.ORGANIZATION_ID = DEL.ORGANIZATION_ID
1208: AND HZ_SITES.PARTY_SITE_ID = ORG_SITES.CARRIER_SITE_ID
1209: AND HZ_SITES.PARTY_ID = C_CARRIER_ID
1210: AND ORG_SITES.ENABLED_FLAG = 'Y'

Line 1464: l_address_line_1 hz_locations.address1%TYPE;

1460: return(true);
1461: end;
1462: FUNCTION Address_New(cf_bill_to_loc in number) RETURN VARCHAR2 IS
1463: l_location_id NUMBER;
1464: l_address_line_1 hz_locations.address1%TYPE;
1465: l_address_line_2 hz_locations.address2%TYPE;
1466: l_address_line_3 hz_locations.address3%TYPE;
1467: l_address_line_4 hz_locations.address4%TYPE;
1468: l_town_or_city hz_locations.city%TYPE;

Line 1465: l_address_line_2 hz_locations.address2%TYPE;

1461: end;
1462: FUNCTION Address_New(cf_bill_to_loc in number) RETURN VARCHAR2 IS
1463: l_location_id NUMBER;
1464: l_address_line_1 hz_locations.address1%TYPE;
1465: l_address_line_2 hz_locations.address2%TYPE;
1466: l_address_line_3 hz_locations.address3%TYPE;
1467: l_address_line_4 hz_locations.address4%TYPE;
1468: l_town_or_city hz_locations.city%TYPE;
1469: l_region hz_locations.county%TYPE;

Line 1466: l_address_line_3 hz_locations.address3%TYPE;

1462: FUNCTION Address_New(cf_bill_to_loc in number) RETURN VARCHAR2 IS
1463: l_location_id NUMBER;
1464: l_address_line_1 hz_locations.address1%TYPE;
1465: l_address_line_2 hz_locations.address2%TYPE;
1466: l_address_line_3 hz_locations.address3%TYPE;
1467: l_address_line_4 hz_locations.address4%TYPE;
1468: l_town_or_city hz_locations.city%TYPE;
1469: l_region hz_locations.county%TYPE;
1470: l_postal_code hz_locations.postal_code%TYPE;

Line 1467: l_address_line_4 hz_locations.address4%TYPE;

1463: l_location_id NUMBER;
1464: l_address_line_1 hz_locations.address1%TYPE;
1465: l_address_line_2 hz_locations.address2%TYPE;
1466: l_address_line_3 hz_locations.address3%TYPE;
1467: l_address_line_4 hz_locations.address4%TYPE;
1468: l_town_or_city hz_locations.city%TYPE;
1469: l_region hz_locations.county%TYPE;
1470: l_postal_code hz_locations.postal_code%TYPE;
1471: l_country fnd_territories_tl.territory_short_name%TYPE;

Line 1468: l_town_or_city hz_locations.city%TYPE;

1464: l_address_line_1 hz_locations.address1%TYPE;
1465: l_address_line_2 hz_locations.address2%TYPE;
1466: l_address_line_3 hz_locations.address3%TYPE;
1467: l_address_line_4 hz_locations.address4%TYPE;
1468: l_town_or_city hz_locations.city%TYPE;
1469: l_region hz_locations.county%TYPE;
1470: l_postal_code hz_locations.postal_code%TYPE;
1471: l_country fnd_territories_tl.territory_short_name%TYPE;
1472: BEGIN

Line 1469: l_region hz_locations.county%TYPE;

1465: l_address_line_2 hz_locations.address2%TYPE;
1466: l_address_line_3 hz_locations.address3%TYPE;
1467: l_address_line_4 hz_locations.address4%TYPE;
1468: l_town_or_city hz_locations.city%TYPE;
1469: l_region hz_locations.county%TYPE;
1470: l_postal_code hz_locations.postal_code%TYPE;
1471: l_country fnd_territories_tl.territory_short_name%TYPE;
1472: BEGIN
1473: SELECT loc_bill.address1,

Line 1470: l_postal_code hz_locations.postal_code%TYPE;

1466: l_address_line_3 hz_locations.address3%TYPE;
1467: l_address_line_4 hz_locations.address4%TYPE;
1468: l_town_or_city hz_locations.city%TYPE;
1469: l_region hz_locations.county%TYPE;
1470: l_postal_code hz_locations.postal_code%TYPE;
1471: l_country fnd_territories_tl.territory_short_name%TYPE;
1472: BEGIN
1473: SELECT loc_bill.address1,
1474: loc_bill.address2,

Line 1489: FROM hz_locations loc_bill,

1485: l_town_or_city,
1486: l_region,
1487: l_postal_code,
1488: l_country
1489: FROM hz_locations loc_bill,
1490: fnd_territories_tl terr_bill
1491: WHERE loc_bill.country = terr_bill.territory_code(+)
1492: AND decode(loc_bill.country,null,userenv('LANG'),terr_bill.language) = userenv('LANG')
1493: AND loc_bill.location_id =cf_bill_to_loc;