APPS.OKS_IMPORT_VALIDATE dependencies on CSI_SYSTEMS_B
Line 4065: ,CSI_SYSTEMS_B CSYSID
4061: ,COUNT(DISTINCT CSYSID.ROWID) OVER (PARTITION BY CLI.ROWID) CSYSID_COUNT
4062: ,MAX(CLI.COVERED_SYSTEM_ID) OVER (PARTITION BY CLI.ROWID) CSYSID_ID --COVERED SYSTEM ID Based on Id
4063:
4064: FROM OKS_COVERED_LEVELS_INTERFACE CLI 4065: ,CSI_SYSTEMS_B CSYSID 4066:
4067: WHERE CLI.COVERED_SYSTEM_ID = CSYSID.SYSTEM_ID (+)) NAMEID_Q
4068:
4069: WHERE OCLI.COVERED_LEVEL_INTERFACE_ID = NAMEID_Q.COVERED_LEVEL_INTERFACE_ID