FND Design Data [Home] [Help]

View: HR_POS_BASE_V

Product: PER - Human Resources
Description:
Implementation/DBA Data: ViewAPPS.HR_POS_BASE_V
View Text

SELECT POSITION_ID
, BUSINESS_GROUP_ID
, DATE_EFFECTIVE
, DATE_END
, NAME
, JOB_ID
, ORGANIZATION_ID FROM HR_POSITIONS_F
WHERE (STATUS IS NULL OR STATUS <> 'INVALID')

Columns

Name
POSITION_ID
BUSINESS_GROUP_ID
DATE_EFFECTIVE
DATE_END
NAME
JOB_ID
ORGANIZATION_ID