[Home] [Help]
View: WIP_PCB_FLOW_ASSEMBLIES_V
View Text
SELECT MSIK.ORGANIZATION_ID
, BOR.LINE_ID
, MSIK.INVENTORY_ITEM_ID
, BOR.ALTERNATE_ROUTING_DESIGNATOR
, TRUNC(MRIR.EFFECTIVITY_DATE) EFFECTIVITY_DATE
, MRIR.PROCESS_REVISION
, BOS.OPERATION_SEQUENCE_ID
, 1
, MSIK.CONCATENATED_SEGMENTS "ASSEMBLY_NAME"
, MSIK.CONCATENATED_SEGMENTS||':'||BOR.ALTERNATE_ROUTING_DESIGNATOR||':' ||MRIR.PROCESS_REVISION||':'||BOS.OPERATION_SEQ_NUM "NODE_LABEL"
, BOS.STANDARD_OPERATION_ID
FROM 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 WIP_SFCB_UTILITIES.LINE_OP_IS_PENDING ( BOS.OPERATION_SEQ_NUM
, BOR.COMMON_ROUTING_SEQUENCE_ID
, MSIK.INVENTORY_ITEM_ID
, MSIK.ORGANIZATION_ID
, BOR.ALTERNATE_ROUTING_DESIGNATOR ) = 1 WITH READ ONLY
Columns
Name |
ORGANIZATION_ID |
LINE_ID |
INVENTORY_ITEM_ID |
ALTERNATE_ROUTING_DESIGNATOR |
EFFECTIVITY_DATE |
PROCESS_REVISION |
OPERATION_SEQUENCE_ID |
NODE_TYPE |
ASSEMBLY_NAME |
NODE_LABEL |
STANDARD_OPERATION_ID |