[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 |