[Home] [Help]
View: PAY_JP_SWOT_NUMBERS_V
Product: | PAY - Payroll |
Description: | This view is used for Japanese localization only. |
Implementation/DBA Data: |
APPS.PAY_JP_SWOT_NUMBERS_V
|
View Text
SELECT ROWIDTOCHAR(PJSN.ROWID)
, PJSN.ORGANIZATION_ID
, PJSN.DISTRICT_CODE
, PJAL1.ADDRESS_LINE_1
, PJSN.REPORT_DISTRICT_CODE
, PJAL2.ADDRESS_LINE_1
, PJSN.SWOT_NUMBER
, PJSN.LAST_UPDATE_DATE
, PJSN.LAST_UPDATED_BY
, PJSN.LAST_UPDATE_LOGIN
, PJSN.CREATED_BY
, PJSN.CREATION_DATE
FROM PAY_JP_SWOT_NUMBERS PJSN
, PER_JP_ADDRESS_LOOKUPS PJAL1
, PER_JP_ADDRESS_LOOKUPS PJAL2
WHERE SUBSTRB(PJSN.DISTRICT_CODE
, 1
, 5) = PJAL1.DISTRICT_CODE
AND SUBSTRB(PJSN.REPORT_DISTRICT_CODE
, 1
, 5) = PJAL2.DISTRICT_CODE(+)
Columns
Name |
ROW_ID |
ORGANIZATION_ID |
DISTRICT_CODE |
DISTRICT_NAME |
REPORT_DISTRICT_CODE |
REPORT_DISTRICT_NAME |
SWOT_NUMBER |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |