eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WIPBV_WIP_OPERATION_RESOURCES

Source

View Text - Preformatted


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

View Text - HTML Formatted

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