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