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.

[Home] [Help]

APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on HZ_LOCATIONS

Line 1415: HZ_LOCATIONS LOC

1411: FROM
1412: WSH_ORG_CARRIER_SITES ORG_SITES,
1413: WSH_NEW_DELIVERIES DEL,
1414: HZ_PARTY_SITES HZ_SITES,
1415: HZ_LOCATIONS LOC
1416: WHERE ORG_SITES.ORGANIZATION_ID = DEL.ORGANIZATION_ID
1417: AND HZ_SITES.PARTY_SITE_ID = ORG_SITES.CARRIER_SITE_ID
1418: AND HZ_SITES.PARTY_ID = C_CARRIER_ID
1419: AND ORG_SITES.ENABLED_FLAG = 'Y'

Line 1443: HZ_LOCATIONS LOC

1439: FROM
1440: WSH_ORG_CARRIER_SITES ORG_SITES,
1441: WSH_NEW_DELIVERIES DEL,
1442: HZ_PARTY_SITES HZ_SITES,
1443: HZ_LOCATIONS LOC
1444: WHERE ORG_SITES.ORGANIZATION_ID = DEL.ORGANIZATION_ID
1445: AND HZ_SITES.PARTY_SITE_ID = ORG_SITES.CARRIER_SITE_ID
1446: AND HZ_SITES.PARTY_ID = C_CARRIER_ID
1447: AND ORG_SITES.ENABLED_FLAG = 'Y'

Line 1701: l_address_line_1 hz_locations.address1%TYPE;

1697: return(true);
1698: end;
1699: FUNCTION Address_New(cf_bill_to_loc in number) RETURN VARCHAR2 IS
1700: l_location_id NUMBER;
1701: l_address_line_1 hz_locations.address1%TYPE;
1702: l_address_line_2 hz_locations.address2%TYPE;
1703: l_address_line_3 hz_locations.address3%TYPE;
1704: l_address_line_4 hz_locations.address4%TYPE;
1705: l_town_or_city hz_locations.city%TYPE;

Line 1702: l_address_line_2 hz_locations.address2%TYPE;

1698: end;
1699: FUNCTION Address_New(cf_bill_to_loc in number) RETURN VARCHAR2 IS
1700: l_location_id NUMBER;
1701: l_address_line_1 hz_locations.address1%TYPE;
1702: l_address_line_2 hz_locations.address2%TYPE;
1703: l_address_line_3 hz_locations.address3%TYPE;
1704: l_address_line_4 hz_locations.address4%TYPE;
1705: l_town_or_city hz_locations.city%TYPE;
1706: l_region hz_locations.county%TYPE;

Line 1703: l_address_line_3 hz_locations.address3%TYPE;

1699: FUNCTION Address_New(cf_bill_to_loc in number) RETURN VARCHAR2 IS
1700: l_location_id NUMBER;
1701: l_address_line_1 hz_locations.address1%TYPE;
1702: l_address_line_2 hz_locations.address2%TYPE;
1703: l_address_line_3 hz_locations.address3%TYPE;
1704: l_address_line_4 hz_locations.address4%TYPE;
1705: l_town_or_city hz_locations.city%TYPE;
1706: l_region hz_locations.county%TYPE;
1707: l_postal_code hz_locations.postal_code%TYPE;

Line 1704: l_address_line_4 hz_locations.address4%TYPE;

1700: l_location_id NUMBER;
1701: l_address_line_1 hz_locations.address1%TYPE;
1702: l_address_line_2 hz_locations.address2%TYPE;
1703: l_address_line_3 hz_locations.address3%TYPE;
1704: l_address_line_4 hz_locations.address4%TYPE;
1705: l_town_or_city hz_locations.city%TYPE;
1706: l_region hz_locations.county%TYPE;
1707: l_postal_code hz_locations.postal_code%TYPE;
1708: l_country fnd_territories_tl.territory_short_name%TYPE;

Line 1705: l_town_or_city hz_locations.city%TYPE;

1701: l_address_line_1 hz_locations.address1%TYPE;
1702: l_address_line_2 hz_locations.address2%TYPE;
1703: l_address_line_3 hz_locations.address3%TYPE;
1704: l_address_line_4 hz_locations.address4%TYPE;
1705: l_town_or_city hz_locations.city%TYPE;
1706: l_region hz_locations.county%TYPE;
1707: l_postal_code hz_locations.postal_code%TYPE;
1708: l_country fnd_territories_tl.territory_short_name%TYPE;
1709: BEGIN

Line 1706: l_region hz_locations.county%TYPE;

1702: l_address_line_2 hz_locations.address2%TYPE;
1703: l_address_line_3 hz_locations.address3%TYPE;
1704: l_address_line_4 hz_locations.address4%TYPE;
1705: l_town_or_city hz_locations.city%TYPE;
1706: l_region hz_locations.county%TYPE;
1707: l_postal_code hz_locations.postal_code%TYPE;
1708: l_country fnd_territories_tl.territory_short_name%TYPE;
1709: BEGIN
1710: SELECT loc_bill.address1,

Line 1707: l_postal_code hz_locations.postal_code%TYPE;

1703: l_address_line_3 hz_locations.address3%TYPE;
1704: l_address_line_4 hz_locations.address4%TYPE;
1705: l_town_or_city hz_locations.city%TYPE;
1706: l_region hz_locations.county%TYPE;
1707: l_postal_code hz_locations.postal_code%TYPE;
1708: l_country fnd_territories_tl.territory_short_name%TYPE;
1709: BEGIN
1710: SELECT loc_bill.address1,
1711: loc_bill.address2,

Line 1726: FROM hz_locations loc_bill,

1722: l_town_or_city,
1723: l_region,
1724: l_postal_code,
1725: l_country
1726: FROM hz_locations loc_bill,
1727: fnd_territories_tl terr_bill
1728: WHERE loc_bill.country = terr_bill.territory_code(+)
1729: AND decode(loc_bill.country,null,userenv('LANG'),terr_bill.language) = userenv('LANG')
1730: AND loc_bill.location_id =cf_bill_to_loc;