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]

View: PER_JP_POSTAL_CODE_LOV_V

Product:	PER - Human Resources
Description:	View used by the web lov attatched to the postal code segment of the JP address style
Implementation/DBA Data:	APPS.PER_JP_POSTAL_CODE_LOV_V

View Text

SELECT PC.POSTAL_CODE
, PC.POSTAL_CODE
, AL.DISTRICT_CODE
, AL.ADDRESS_LINE_1
, AL.ADDRESS_LINE_1_KANA
, PC.REGION
, PC.REGION_KANA
FROM PER_JP_POSTAL_CODES PC
, PER_JP_ADDRESS_LOOKUPS AL
WHERE PC.DISTRICT_CODE = AL.DISTRICT_CODE

Columns

Name
POSTAL_CODE_PK
POSTAL_CODE
DISTRICT_CODE
ADDRESS_LINE_1
ADDRESS_LINE_1_KANA
ADDRESS_LINE_2
ADDRESS_LINE_2_KANA