158: 'Z',
159: rank_id,
160: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
161: 1
162: FROM AS_SALES_LEAD_RANKS_VL a
163: --WHERE enabled_flag = 'Y'
164: WHERE to_char(a.rank_id)
165: NOT IN
166: ( SELECT object_def from BIM_R_CODE_DEFINITIONS WHERE object_type = 'RANK' and column_name in ('A','B','C','D')
284: 'Z',
285: rank_id,
286: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
287: 1
288: FROM AS_SALES_LEAD_RANKS_VL a
289: --WHERE enabled_flag = 'Y'
290: WHERE to_char(a.rank_id)
291: NOT IN
292: ( SELECT object_def from BIM_R_CODE_DEFINITIONS WHERE object_type = 'RANK')
353: 'Z',
354: rank_id,
355: BIM_R_CODE_DEFINITIONS_s.NEXTVAL,
356: 1
357: FROM AS_SALES_LEAD_RANKS_VL a
358: --WHERE enabled_flag = 'Y'
359: WHERE to_char(a.rank_id)
360: NOT IN
361: ( SELECT object_def from BIM_R_CODE_DEFINITIONS WHERE object_type = 'RANK')