View: WIPFV_WIP_OPERATION_RESOURCES

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPFV_WIP_OPERATION_RESOURCES

View Text

SELECT OPRE.RESOURCE_SEQ_NUM
, OPRE.USAGE_RATE_OR_AMOUNT
, OPRE.ASSIGNED_UNITS
, '_LA:OPRE.SCHEDULED_FLAG:MFG_LOOKUPS:BOM_RESOURCE_SCHEDULE_TYPE:MEANING'
, '_LA:OPRE.AUTOCHARGE_TYPE:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING'
, OPRE.APPLIED_RESOURCE_UNITS
, '_LA:OPRE.PHANTOM_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, OPRE.START_DATE
, OPRE.COMPLETION_DATE
, EN.WIP_ENTITY_NAME
, ST.OPERATION_CODE
, DE.DEPARTMENT_CODE
, PA.ORGANIZATION_CODE
, AL.NAME
, RE.RESOURCE_CODE
, AC.ACTIVITY
, '_DF:BOM:OPERATION_RESOURCES:OPRE'
, OPRE.WIP_ENTITY_ID
, OPRE.REPETITIVE_SCHEDULE_ID
, OPRE.OPERATION_SEQ_NUM
, OPRE.ORGANIZATION_ID
, OPRE.RESOURCE_ID
, OPRE.DEPARTMENT_ID
, OPRE.ACTIVITY_ID
, OPRE.CREATION_DATE
, OPRE.CREATED_BY
, OPRE.LAST_UPDATE_DATE
, OPRE.LAST_UPDATED_BY
FROM WIP_OPERATIONS OP
, BOM_STANDARD_OPERATIONS ST
, WIP_ENTITIES EN
, WIP_DISCRETE_JOBS DI
, WIP_REPETITIVE_SCHEDULES RESC
, CST_ACTIVITIES AC
, BOM_RESOURCES RE
, BOM_DEPARTMENTS DE
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_OPERATION_RESOURCES OPRE
WHERE OPRE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND OPRE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND OPRE.RESOURCE_ID = RE.RESOURCE_ID
AND OPRE.DEPARTMENT_ID = DE.DEPARTMENT_ID(+)
AND NVL(OPRE.REPETITIVE_SCHEDULE_ID
, -1) = NVL(RESC.REPETITIVE_SCHEDULE_ID
, -1)
AND OPRE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND OPRE.WIP_ENTITY_ID = OP.WIP_ENTITY_ID
AND NVL(OPRE.REPETITIVE_SCHEDULE_ID
, -1) = NVL(OP.REPETITIVE_SCHEDULE_ID
, -1)
AND OPRE.ORGANIZATION_ID = OP.ORGANIZATION_ID
AND OPRE.OPERATION_SEQ_NUM = OP.OPERATION_SEQ_NUM
AND OPRE.ACTIVITY_ID = AC.ACTIVITY_ID(+)
AND OPRE.REPETITIVE_SCHEDULE_ID = RESC.REPETITIVE_SCHEDULE_ID(+)
AND OPRE.ORGANIZATION_ID = RESC.ORGANIZATION_ID(+)
AND OPRE.WIP_ENTITY_ID = DI.WIP_ENTITY_ID(+)
AND OPRE.ORGANIZATION_ID = DI.ORGANIZATION_ID(+)
AND OP.STANDARD_OPERATION_ID = ST.STANDARD_OPERATION_ID(+)
AND '_SEC:OPRE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns