View: WIP_PCB_OPEN_FLOW_SCHEDULES_V

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

View Text

SELECT WFS.ORGANIZATION_ID
, WFS.LINE_ID
, WFS.WIP_ENTITY_ID
, BOS.OPERATION_SEQUENCE_ID
, 1
, MSIK.CONCATENATED_SEGMENTS||':'|| WIP_SFCB_UTILITIES.DATE_TO_DISPLAYDATE_TZ(WFS.SCHEDULED_COMPLETION_DATE)||':'|| WSG.SCHEDULE_GROUP_NAME||':'||WFS.BUILD_SEQUENCE "NODE_LABEL"
, WFS.SCHEDULED_COMPLETION_DATE
, WSG.SCHEDULE_GROUP_NAME
, WFS.BUILD_SEQUENCE
, MSIK.CONCATENATED_SEGMENTS
, BOS.STANDARD_OPERATION_ID
FROM MTL_SYSTEM_ITEMS_KFV MSIK
, WIP_SCHEDULE_GROUPS WSG
, BOM_OPERATION_SEQUENCES BOS
, BOM_OPERATIONAL_ROUTINGS BOR
, WIP_FLOW_SCHEDULES WFS
WHERE WFS.SCHEDULED_FLAG = 1
AND BOR.ORGANIZATION_ID = WFS.ORGANIZATION_ID AND BOR.ASSEMBLY_ITEM_ID = WFS.PRIMARY_ITEM_ID AND BOR.LINE_ID = WFS.LINE_ID AND BOR.CFM_ROUTING_FLAG = 1 AND DECODE(BOR.ALTERNATE_ROUTING_DESIGNATOR
, NULL
, '@@@@@@@'
, BOR.ALTERNATE_ROUTING_DESIGNATOR) = DECODE(WFS.ALTERNATE_ROUTING_DESIGNATOR
, NULL
, '@@@@@@@'
, WFS.ALTERNATE_ROUTING_DESIGNATOR) AND NVL(BOS.OPERATION_TYPE
, 1) = 3 /* LINE OPERATION */ AND BOS.ROUTING_SEQUENCE_ID = BOR.COMMON_ROUTING_SEQUENCE_ID AND WSG.ORGANIZATION_ID (+) = WFS.ORGANIZATION_ID AND WSG.SCHEDULE_GROUP_ID (+) = WFS.SCHEDULE_GROUP_ID AND MSIK.ORGANIZATION_ID = WFS.ORGANIZATION_ID AND MSIK.INVENTORY_ITEM_ID = WFS.PRIMARY_ITEM_ID AND WFS.STATUS <> 2 AND WIP_SFCB_UTILITIES.LINE_OP_IS_PENDING ( BOS.OPERATION_SEQ_NUM
, BOR.COMMON_ROUTING_SEQUENCE_ID
, WFS.PRIMARY_ITEM_ID
, WFS.ORGANIZATION_ID
, WFS.ALTERNATE_ROUTING_DESIGNATOR
, WFS.CURRENT_LINE_OPERATION /* WILL CHANGE TO CURRENT LINE OPERATION */ ) = 1 WITH READ ONLY

Columns