VIEW: APPS.WIPFV_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 , '_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

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
, '_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