540: FROM jts_configurations_vl c,
541: fnd_lookup_values_vl l,
542: fnd_lookup_values_vl lf,
543: jts_setup_flows_vl fl,
544: fnd_user u1,
545: fnd_user u2
546: WHERE c.configuration_id = p_config_id
547: AND fl.flow_id = c.flow_id
548: AND l.lookup_type = C_RECORD_MODE_TYPE
541: fnd_lookup_values_vl l,
542: fnd_lookup_values_vl lf,
543: jts_setup_flows_vl fl,
544: fnd_user u1,
545: fnd_user u2
546: WHERE c.configuration_id = p_config_id
547: AND fl.flow_id = c.flow_id
548: AND l.lookup_type = C_RECORD_MODE_TYPE
549: AND l.lookup_code = c.record_mode
638: ' FROM jts_configurations_vl c, ' ||
639: ' fnd_lookup_values_vl l, ' ||
640: ' fnd_lookup_values_vl lf, ' ||
641: ' jts_setup_flows_vl fl, ' ||
642: ' fnd_user u1, ' ||
643: ' fnd_user u2 ' ||
644: ' WHERE fl.flow_id = c.flow_id ' ||
645: ' AND l.lookup_type = ''' || C_RECORD_MODE_TYPE ||
646: ''' AND l.lookup_code = c.record_mode ' ||
639: ' fnd_lookup_values_vl l, ' ||
640: ' fnd_lookup_values_vl lf, ' ||
641: ' jts_setup_flows_vl fl, ' ||
642: ' fnd_user u1, ' ||
643: ' fnd_user u2 ' ||
644: ' WHERE fl.flow_id = c.flow_id ' ||
645: ' AND l.lookup_type = ''' || C_RECORD_MODE_TYPE ||
646: ''' AND l.lookup_code = c.record_mode ' ||
647: ' AND lf.lookup_type = ''' || C_FLOW_TYPE ||