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: 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.EFILE_EXCLUSIVE_FLAG
, PJSN.OUTPUT_FILE_NAME
, PJSN.IMPORT_EXCLUSIVE_FLAG
, PJSN.INPUT_FILE_NAME
, 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
EFILE_EXCLUSIVE_FLAG
OUTPUT_FILE_NAME
IMPORT_EXCLUSIVE_FLAG
INPUT_FILE_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE