View: WIPBV_WIP_EMPLOYEE_LABOR_RATES

Product:	WIP - Work in Process
Description:	Employee labor rate and labor rate effective date information.
Implementation/DBA Data:	APPS.WIPBV_WIP_EMPLOYEE_LABOR_RATES

View Text

SELECT PE.FULL_NAME
, EM.EFFECTIVE_DATE
, EM.HOURLY_LABOR_RATE
, PA.ORGANIZATION_CODE
, AL.NAME
, EM.EMPLOYEE_ID
, EM.ORGANIZATION_ID
, EM.CREATION_DATE
, EM.CREATED_BY
, EM.LAST_UPDATE_DATE
, EM.LAST_UPDATED_BY
FROM PER_ALL_PEOPLE_F PE
, WIP_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_EMPLOYEE_LABOR_RATES EM
WHERE EM.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND EM.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND EM.ORGANIZATION_ID = PARA.ORGANIZATION_ID
AND EM.EMPLOYEE_ID = PE.PERSON_ID
AND EM.EFFECTIVE_DATE >= PE.EFFECTIVE_START_DATE
AND EM.EFFECTIVE_DATE <=PE.EFFECTIVE_END_DATE
AND '_SEC:EM.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns