[Home] [Help]
View: WIP_PCB_RES_INST_EMPLOYEES_V
View Text
SELECT BD.ORGANIZATION_ID
, BD.DEPARTMENT_ID
, BR.RESOURCE_ID
, BR.RESOURCE_CODE
, BREM.INSTANCE_ID
, PAPF.FULL_NAME
, BREM.PERSON_ID "EMPLOYEE_ID"
FROM BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
, BOM_DEPARTMENT_RESOURCES BDR
, BOM_RESOURCE_EMPLOYEES BREM
, PER_ALL_PEOPLE_F PAPF
WHERE BR.RESOURCE_ID = BDR.RESOURCE_ID
AND BD.DEPARTMENT_ID = BDR.DEPARTMENT_ID
AND BREM.RESOURCE_ID = BDR.RESOURCE_ID
AND BR.RESOURCE_TYPE = 2
AND PAPF.EFFECTIVE_START_DATE = BREM.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE = BREM.EFFECTIVE_END_DATE
AND PAPF.PERSON_ID = BREM.PERSON_ID WITH READ ONLY
Columns
Name |
ORGANIZATION_ID |
DEPARTMENT_ID |
RESOURCE_ID |
RESOURCE_CODE |
INSTANCE_ID |
INSTANCE_NAME |
EMPLOYEE_ID |