DBA Data[Home] [Help]

VIEW: APPS.HR_POS_BASE_V

Source

View Text - Preformatted

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')
View Text - HTML Formatted

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')