View: WIP_OPEN_FLOW_SCHEDULES_V

Product:	WIP - Work in Process
Description:	This view is used to retrieve open flow schedules.
Implementation/DBA Data:	APPS.WIP_OPEN_FLOW_SCHEDULES_V

View Text

SELECT MSIK.CONCATENATED_SEGMENTS||':'|| WIP_SFCB_UTILITIES.DATE_TO_DISPLAYDATE_TZ(WFS.SCHEDULED_COMPLETION_DATE)||':'|| WSG.SCHEDULE_GROUP_NAME||':'||WFS.BUILD_SEQUENCE "NODE_LABEL"
, WFS.ORGANIZATION_ID
, /* FK */ WFS.LINE_ID
, /* FK */ WFS.WIP_ENTITY_ID
, /* PK */ BOS.OPERATION_SEQUENCE_ID
, /* PK */ BOS.STANDARD_OPERATION_ID
, /* FK */ WFS.SCHEDULE_NUMBER
, WFS.SCHEDULED_START_DATE
, WFS.SCHEDULED_COMPLETION_DATE
, BOR.ROUTING_SEQUENCE_ID
, BOS.OPERATION_SEQ_NUM
, WSG.SCHEDULE_GROUP_NAME
, WFS.BUILD_SEQUENCE
, WFS.PRIMARY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS "ASSEMBLY_NAME"
, WL.LINE_CODE
, WFS.END_ITEM_UNIT_NUMBER
, WFS.PLANNED_QUANTITY
, WFS.QUANTITY_COMPLETED
, WFS.ALTERNATE_BOM_DESIGNATOR
, WFS.ALTERNATE_ROUTING_DESIGNATOR
, WFS.BOM_REVISION
, WFS.BOM_REVISION_DATE
, WFS.ROUTING_REVISION
, WFS.ROUTING_REVISION_DATE
, MSO.CONCATENATED_SEGMENTS "SALES_ORDER_NUMBER"
, PJM_PROJECT.ALL_PROJ_IDTONAME(WFS.PROJECT_ID)
, PJM_PROJECT.ALL_TASK_IDTONAME(WFS.TASK_ID)
, MKC.KANBAN_CARD_NUMBER
, WFS.CURRENT_LINE_OPERATION
, 1 "NODE_TYPE"
, BOS.STANDARD_OPERATION_CODE
, MSIK.DESCRIPTION "ASSEMBLY_DESCRIPTION"
, FND_DATE.DATE_TO_DISPLAYDATE(WFS.SCHEDULED_COMPLETION_DATE) "SCHEDULED_COMPL_DISPLAYDATE"
FROM MTL_KANBAN_CARDS MKC
, MTL_SALES_ORDERS_KFV MSO
, WIP_LINES WL
, MTL_SYSTEM_ITEMS_KFV MSIK
, WIP_SCHEDULE_GROUPS WSG
, BOM_OPERATION_SEQUENCES_V 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 BOS.OPERATION_TYPE = 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 WL.LINE_ID = WFS.LINE_ID AND WL.ORGANIZATION_ID = WFS.ORGANIZATION_ID AND MSIK.ORGANIZATION_ID = WFS.ORGANIZATION_ID AND MSIK.INVENTORY_ITEM_ID = WFS.PRIMARY_ITEM_ID AND MSO.SALES_ORDER_ID (+) = WFS.DEMAND_SOURCE_HEADER_ID AND MKC.KANBAN_CARD_ID (+) = WFS.KANBAN_CARD_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

Columns