View: WIPBV_WIP_OPERATION_RESOURCES

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPBV_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
, OPRE.START_DATE
, OPRE.COMPLETION_DATE
, EN.WIP_ENTITY_NAME
, ST.OPERATION_CODE
, '_LA:OPRE.PHANTOM_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, OPRE.WIP_ENTITY_ID
, OPRE.REPETITIVE_SCHEDULE_ID
, OPRE.OPERATION_SEQ_NUM
, OPRE.ORGANIZATION_ID
, OPRE.RESOURCE_ID
, OPRE.ACTIVITY_ID
, OPRE.DEPARTMENT_ID
, OPRE.CREATION_DATE
, OPRE.CREATED_BY
, OPRE.LAST_UPDATE_DATE
, OPRE.LAST_UPDATED_BY
FROM WIP_OPERATIONS OP
, WIP_ENTITIES EN
, WIP_DISCRETE_JOBS DI
, WIP_REPETITIVE_SCHEDULES RE
, BOM_STANDARD_OPERATIONS ST
, BOM_DEPARTMENTS DE
, WIP_OPERATION_RESOURCES OPRE
WHERE NVL(OPRE.REPETITIVE_SCHEDULE_ID
, -1) = NVL(RE.REPETITIVE_SCHEDULE_ID
, -1)
AND OPRE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND OPRE.DEPARTMENT_ID = DE.DEPARTMENT_ID
AND OP.STANDARD_OPERATION_ID = ST.STANDARD_OPERATION_ID(+)
AND OPRE.REPETITIVE_SCHEDULE_ID = RE.REPETITIVE_SCHEDULE_ID(+)
AND OPRE.ORGANIZATION_ID = RE.ORGANIZATION_ID(+)
AND OPRE.WIP_ENTITY_ID = DI.WIP_ENTITY_ID(+)
AND OPRE.ORGANIZATION_ID = DI.ORGANIZATION_ID(+)
AND OPRE.WIP_ENTITY_ID = OP.WIP_ENTITY_ID(+)
AND OPRE.REPETITIVE_SCHEDULE_ID = OP.REPETITIVE_SCHEDULE_ID(+)
AND OPRE.OPERATION_SEQ_NUM = OP.OPERATION_SEQ_NUM(+)
AND OPRE.ORGANIZATION_ID = OP.ORGANIZATION_ID(+)
AND '_SEC:OPRE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns