Product: | WIP - Work in Process |
---|---|
Description: | Employee resource instances |
Implementation/DBA Data: | APPS.WIP_RES_INST_EMPLOYEES_V |
SELECT BD.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, BD.ORGANIZATION_ID
, BR.RESOURCE_ID
, BR.RESOURCE_CODE
, BREM.INSTANCE_ID
, PAPF.FULL_NAME
, BREM.PERSON_ID "EMPLOYEE_ID"
, BDR.CAPACITY_UNITS
, BDR.RESOURCE_GROUP_NAME
, BDR.CTP_FLAG
, BDR.EXCEPTION_SET_NAME
, BDR.ATP_RULE_ID
, NVL(BDR.RESOURCE_DESCRIPTION
, ' ') "RESOURCE_DESCRIPTION"
, NVL(BDR.SHARE_FROM_DEPARTMENT
, BD.DEPARTMENT_CODE) "SHARE_FROM_DEPARTMENT"
, BR.COST_ELEMENT_ID
, BR.PURCHASE_ITEM_ID
, BR.COST_CODE_TYPE
, BR.FUNCTIONAL_CURRENCY_FLAG
, BR.UNIT_OF_MEASURE
, BR.DEFAULT_ACTIVITY_ID
, BR.AUTOCHARGE_TYPE
, BR.STANDARD_RATE_FLAG
, BR.DEFAULT_BASIS_TYPE
, BR.ABSORPTION_ACCOUNT
, BR.ALLOW_COSTS_FLAG
, BR.RATE_VARIANCE_ACCOUNT
, BR.EXPENDITURE_TYPE
, ML1.MEANING "RESOURCE_TYPE"
, ML2.MEANING "AVAILABLE_24_HRS_FLAG"
, ML3.MEANING "BASIS_TYPE"
FROM MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
, BOM_DEPARTMENT_RESOURCES_V 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 ML1.LOOKUP_CODE = BR.RESOURCE_TYPE
AND ML1.LOOKUP_TYPE = 'BOM_RESOURCE_TYPE'
AND ML2.LOOKUP_CODE = BDR.AVAILABLE_24_HOURS_FLAG
AND ML2.LOOKUP_TYPE = 'SYS_YES_NO'
AND ML3.LOOKUP_CODE = BR.DEFAULT_BASIS_TYPE
AND ML3.LOOKUP_TYPE = 'CST_BASIS'
AND BREM.RESOURCE_ID = BDR.RESOURCE_ID
AND BREM.ORGANIZATION_ID = BDR.ORGANIZATION_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