VIEW: APPS.PER_ASSIGNMENT_STATUS_TYPES_V

Source

View Text - Preformatted

SELECT AST.ROWID , AST.ASSIGNMENT_STATUS_TYPE_ID , AST.BUSINESS_GROUP_ID , AST.LEGISLATION_CODE , ASTTL.USER_STATUS , AST.ACTIVE_FLAG , AST.DEFAULT_FLAG , AST.PRIMARY_FLAG , AST.PAY_SYSTEM_STATUS , AST.PER_SYSTEM_STATUS , ASTTL.EXTERNAL_STATUS , AST.LAST_UPDATE_DATE , AST.LAST_UPDATED_BY , AST.LAST_UPDATE_LOGIN , AST.CREATED_BY , AST.CREATION_DATE FROM PER_ASSIGNMENT_STATUS_TYPES_TL ASTTL, PER_ASSIGNMENT_STATUS_TYPES AST WHERE AST.ASSIGNMENT_STATUS_TYPE_ID = ASTTL.ASSIGNMENT_STATUS_TYPE_ID AND ASTTL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT AST.ROWID
, AST.ASSIGNMENT_STATUS_TYPE_ID
, AST.BUSINESS_GROUP_ID
, AST.LEGISLATION_CODE
, ASTTL.USER_STATUS
, AST.ACTIVE_FLAG
, AST.DEFAULT_FLAG
, AST.PRIMARY_FLAG
, AST.PAY_SYSTEM_STATUS
, AST.PER_SYSTEM_STATUS
, ASTTL.EXTERNAL_STATUS
, AST.LAST_UPDATE_DATE
, AST.LAST_UPDATED_BY
, AST.LAST_UPDATE_LOGIN
, AST.CREATED_BY
, AST.CREATION_DATE
FROM PER_ASSIGNMENT_STATUS_TYPES_TL ASTTL
, PER_ASSIGNMENT_STATUS_TYPES AST
WHERE AST.ASSIGNMENT_STATUS_TYPE_ID = ASTTL.ASSIGNMENT_STATUS_TYPE_ID
AND ASTTL.LANGUAGE = USERENV('LANG')