View: WIP_FLOW_ASSEMBLY_EVENTS_V

Product:	WIP - Work in Process
Description:	Flow Workstation base view.
Implementation/DBA Data:	APPS.WIP_FLOW_ASSEMBLY_EVENTS_V

View Text

SELECT BOR.LINE_ID
, BOS2.OPERATION_SEQ_NUM||':'||BSO.OPERATION_CODE "NODE_LABEL"
, MSIK.ORGANIZATION_ID
, MSIK.INVENTORY_ITEM_ID
, BOR.ALTERNATE_ROUTING_DESIGNATOR
, MRIR.PROCESS_REVISION
, TRUNC(MRIR.EFFECTIVITY_DATE) EFFECTIVITY_DATE
, BOS.OPERATION_SEQUENCE_ID "LINE_OPERATION_SEQUENCE_ID"
, /* FK */ BOS2.OPERATION_SEQUENCE_ID
, BOS2.OPERATION_SEQ_NUM
, /* PK */ BSO.OPERATION_CODE
, BOS2.OPERATION_DESCRIPTION
, BOS2.OPERATION_LEAD_TIME_PERCENT
, BOS2.DEPARTMENT_ID
, TRUNC(BOS2.EFFECTIVITY_DATE) EVENT_EFFECTIVITY_DATE
, BOS2.DISABLE_DATE
, BOS2.STANDARD_OPERATION_ID
, BD.DEPARTMENT_CODE
, MSIK.CONCATENATED_SEGMENTS "ASSEMBLY_NAME"
, 2 "NODE_TYPE"
FROM BOM_DEPARTMENTS BD
, BOM_STANDARD_OPERATIONS BSO
, BOM_OPERATION_SEQUENCES BOS2
, BOM_OPERATION_SEQUENCES BOS
, BOM_OPERATIONAL_ROUTINGS BOR
, MTL_ROUTING_REV_HIGHDATE_V MRIR
, MTL_SYSTEM_ITEMS_KFV MSIK
WHERE MRIR.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID AND MRIR.ORGANIZATION_ID = MSIK.ORGANIZATION_ID AND BOR.ASSEMBLY_ITEM_ID = MRIR.INVENTORY_ITEM_ID AND BOR.ORGANIZATION_ID = MRIR.ORGANIZATION_ID AND BOR.CFM_ROUTING_FLAG = 1 AND BOS.ROUTING_SEQUENCE_ID = BOR.COMMON_ROUTING_SEQUENCE_ID AND BOS.OPERATION_TYPE = 3 /* LINE OPERATION TYPE */ AND BOS2.LINE_OP_SEQ_ID = BOS.OPERATION_SEQUENCE_ID AND TRUNC(BOS2.EFFECTIVITY_DATE) <= TRUNC(MRIR.HIGH_DATE) AND (BOS2.DISABLE_DATE IS NULL OR TRUNC(BOS2.DISABLE_DATE) > TRUNC(MRIR.HIGH_DATE)) AND BSO.STANDARD_OPERATION_ID (+) = BOS2.STANDARD_OPERATION_ID AND BD.DEPARTMENT_ID = BOS2.DEPARTMENT_ID

Columns