3841: ,COUNT(DISTINCT CITMSER.ROWID) OVER (PARTITION BY CLI.ROWID) CITMSER_COUNT
3842: ,MAX(CITMSER.INSTANCE_ID) OVER (PARTITION BY CLI.ROWID) CITMSER_ID -- ITEM INSTANCE ID Based on Serial number
3843:
3844: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3845: ,CSI_ITEM_INSTANCES CITMI
3846: ,CSI_ITEM_INSTANCES CITMN
3847: ,CSI_ITEM_INSTANCES CITMSER
3848: WHERE CLI.COVERED_INSTANCE_ID = CITMI.INSTANCE_ID (+)
3849: AND CLI.COVERED_INSTANCE_NUMBER = CITMN.INSTANCE_NUMBER (+)
3842: ,MAX(CITMSER.INSTANCE_ID) OVER (PARTITION BY CLI.ROWID) CITMSER_ID -- ITEM INSTANCE ID Based on Serial number
3843:
3844: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3845: ,CSI_ITEM_INSTANCES CITMI
3846: ,CSI_ITEM_INSTANCES CITMN
3847: ,CSI_ITEM_INSTANCES CITMSER
3848: WHERE CLI.COVERED_INSTANCE_ID = CITMI.INSTANCE_ID (+)
3849: AND CLI.COVERED_INSTANCE_NUMBER = CITMN.INSTANCE_NUMBER (+)
3850: AND CLI.COVERED_SERIAL_NUMBER = CITMSER.SERIAL_NUMBER(+)) NAMEID_Q
3843:
3844: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3845: ,CSI_ITEM_INSTANCES CITMI
3846: ,CSI_ITEM_INSTANCES CITMN
3847: ,CSI_ITEM_INSTANCES CITMSER
3848: WHERE CLI.COVERED_INSTANCE_ID = CITMI.INSTANCE_ID (+)
3849: AND CLI.COVERED_INSTANCE_NUMBER = CITMN.INSTANCE_NUMBER (+)
3850: AND CLI.COVERED_SERIAL_NUMBER = CITMSER.SERIAL_NUMBER(+)) NAMEID_Q
3851: