View: WIP_PCB_EQP_UPS_DISPATCH_V

Product:	WIP - Work in Process
Description:	WIP Production Control Board base view
Implementation/DBA Data:	APPS.WIP_PCB_EQP_UPS_DISPATCH_V

View Text

SELECT WO1.ORGANIZATION_ID
, BD1.DEPARTMENT_ID
, DECODE(COUNT(WOR.RESOURCE_SEQ_NUM)
, 1
, SUM(WOR.RESOURCE_SEQ_NUM)
, NULL) RESOURCE_SEQ_NUM
, WOR.RESOURCE_ID
, WORI.INSTANCE_ID
, MSIK.CONCATENATED_SEGMENTS
, WORI.SERIAL_NUMBER
, WO1.WIP_ENTITY_ID
, WO1.OPERATION_SEQ_NUM
, WE.WIP_ENTITY_NAME || ':' || WO1.OPERATION_SEQ_NUM /* || ':' || WOR.RESOURCE_SEQ_NUM */ "JOB_OP_NAME"
, DECODE(WDJ.STATUS_TYPE
, 6
, 'RED'
, NULL) NODE_TEXT_COLOR
, DECODE(WDJ.STATUS_TYPE
, 6
, 'WPJOBOPH.GIF'
, NULL) NODE_ICON
, WO1.FIRST_UNIT_START_DATE
FROM BOM_STANDARD_OPERATIONS BSO
, BOM_DEPARTMENTS BD1
, WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE
, WIP_OPERATION_RESOURCES WOR
, WIP_OPERATIONS WO1
, WIP_OPERATIONS WO2
, WIP_OP_RESOURCE_INSTANCES WORI
, BOM_RESOURCE_EQUIPMENTS BREQ
, MTL_SYSTEM_ITEMS_KFV MSIK
, BOM_RESOURCES BR
WHERE WOR.ORGANIZATION_ID = WO1.ORGANIZATION_ID
AND WOR.WIP_ENTITY_ID = WO1.WIP_ENTITY_ID
AND WOR.OPERATION_SEQ_NUM = WO1.OPERATION_SEQ_NUM /* YOU DONOT HAVE TO WIRRY ABOUT REPETITIVE SCHEDULES */
AND WE.WIP_ENTITY_ID = WO1.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID = WO1.ORGANIZATION_ID
AND WE.ENTITY_TYPE = 1 /* ENTITY TYPE */
AND WDJ.WIP_ENTITY_ID = WO1.WIP_ENTITY_ID
AND WDJ.ORGANIZATION_ID = WO1.ORGANIZATION_ID
AND WDJ.STATUS_TYPE IN (3
, 4
, 6) /* RELEASED
, COMPLETE CHARGES ALLOWED
,
AND HOLD */
AND WDJ.PRIMARY_ITEM_ID IS NOT NULL
AND BD1.DEPARTMENT_ID = NVL(WOR.DEPARTMENT_ID
, WO1.DEPARTMENT_ID)
AND BD1.ORGANIZATION_ID = WO1.ORGANIZATION_ID
AND WO2.NEXT_OPERATION_SEQ_NUM = WO1.OPERATION_SEQ_NUM
AND WO2.WIP_ENTITY_ID = WO1.WIP_ENTITY_ID
AND WO2.ORGANIZATION_ID = WO1.ORGANIZATION_ID
AND WO2.NEXT_OPERATION_SEQ_NUM = WO1.OPERATION_SEQ_NUM
AND WO2.WIP_ENTITY_ID = WO1.WIP_ENTITY_ID
AND WO2.ORGANIZATION_ID = WO1.ORGANIZATION_ID
AND (WO2.QUANTITY_WAITING_TO_MOVE+WO2.QUANTITY_IN_QUEUE+WO2.QUANTITY_RUNNING)> 0
AND BSO.STANDARD_OPERATION_ID (+) = WO1.STANDARD_OPERATION_ID
AND NVL(BSO.OPERATION_TYPE
, 1) = 1
AND BSO.LINE_ID IS NULL
AND WOR.WIP_ENTITY_ID = WORI.WIP_ENTITY_ID
AND WOR.OPERATION_SEQ_NUM = WORI.OPERATION_SEQ_NUM
AND WOR.RESOURCE_SEQ_NUM = WORI.RESOURCE_SEQ_NUM
AND WORI.INSTANCE_ID = BREQ.INSTANCE_ID
AND BR.RESOURCE_ID = WOR.RESOURCE_ID
AND BR.RESOURCE_TYPE = 1
AND MSIK.ORGANIZATION_ID = BREQ.ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID = BREQ.INVENTORY_ITEM_ID GROUP BY WE.WIP_ENTITY_NAME
, WO1.WIP_ENTITY_ID
, WO1.ORGANIZATION_ID
, WO1.OPERATION_SEQ_NUM
, BD1.DEPARTMENT_ID
, WOR.RESOURCE_ID
, WO1.FIRST_UNIT_START_DATE
, WDJ.STATUS_TYPE
, WORI.INSTANCE_ID
, MSIK.CONCATENATED_SEGMENTS
, WORI.SERIAL_NUMBER WITH READ ONLY

Columns