View: PAY_JP_ITWB_SAL_ACT_ERD_V

Product:	PAY - Payroll
Description:	This view is used for Japanese localization only.
Implementation/DBA Data:	APPS.PAY_JP_ITWB_SAL_ACT_ERD_V

View Text

SELECT ROW_ID
, ACTION_INFORMATION_ID
, OBJECT_VERSION_NUMBER
, ASSIGNMENT_ACTION_ID
, ACTION_CONTEXT_TYPE
, ASSIGNMENT_ID
, EFFECTIVE_DATE
, ACTION_INFORMATION_CATEGORY
, CATEGORY
, FND_DATE.CANONICAL_TO_DATE(COL_MTH1)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH2)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH3)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH4)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH5)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH6)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH7)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH8)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH9)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH10)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH11)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH12)
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM PAY_JP_ITWB_SAL_ACT_V
WHERE CATEGORY = 'ERD'

Columns