DBA Data[Home] [Help]

APPS.HZ_ACCOUNT_MERGE_PUB dependencies on FND_TERRITORIES_VL

Line 1396: FND_TERRITORIES_VL TERR

1392: , LOC.PROVINCE
1393: , LOC.POSTAL_CODE
1394: , TERR.TERRITORY_SHORT_NAME ),1,240) INTO l_from_address
1395: FROM hz_locations loc,
1396: FND_TERRITORIES_VL TERR
1397: WHERE loc.location_id = l_from_location_id
1398: and LOC.COUNTRY = TERR.TERRITORY_CODE (+);
1399:
1400: select substr(ARP_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE

Line 1412: FND_TERRITORIES_VL TERR

1408: , LOC.PROVINCE
1409: , LOC.POSTAL_CODE
1410: , TERR.TERRITORY_SHORT_NAME ),1,240) INTO l_to_address
1411: FROM hz_locations loc,
1412: FND_TERRITORIES_VL TERR
1413: WHERE loc.location_id = l_to_location_id
1414: and LOC.COUNTRY = TERR.TERRITORY_CODE (+);
1415:
1416: IF (l_account_merge_request_obj.site_merge_details(i).site_use_merge_details IS NOT NULL AND