DBA Data[Home] [Help]

APPS.OE_NOTIFY_USER_WF dependencies on DUAL

Line 109: FROM dual;

105: decode(l_line_rec.component_number, null, '.' , null) ||
106: decode(l_line_rec.option_number, null, '.', null ) ||
107: '.'|| to_char(l_line_rec.service_number)) LINE_NUM
108: INTO l_line_num
109: FROM dual;
110:
111: l_line_text := 'Line Details' || newline
112: ||'-----------------' || newline
113: ||'Line Number : ' || l_line_num || newline

Line 153: FROM dual;

149: decode(l_line_rec.component_number, null, '.' , null) ||
150: decode(l_line_rec.option_number, null, '.', null ) ||
151: '.'|| to_char(l_line_rec.service_number)) LINE_NUM
152: INTO l_line_num
153: FROM dual;
154:
155: l_line_text := l_line_text || newline
156: ||'Model Line Details' || newline
157: ||'--------------------------' || newline