APPS.OE_SO_ATO dependencies on SO_LINES

Line 146: FROM SO_LINES

142: END;
143:
144: SELECT TO_CHAR(CREATION_DATE,'YYYY/MM/DD HH24:MI')
145: INTO x_creation_date_time
146: FROM SO_LINES
147: WHERE LINE_ID = x_line_id;
148:
149:
150: SELECT a.name, r.name, to_char(l.s27_date, 'YYYY/MM/DD HH24:MI')

Line 154: SO_LINES L

150: SELECT a.name, r.name, to_char(l.s27_date, 'YYYY/MM/DD HH24:MI')
151: INTO x_mfg_action, x_mfg_result, x_action_date
152: FROM SO_ACTIONS A,
153: SO_RESULTS R,
154: SO_LINES L
155: WHERE
156: L.LINE_ID = x_line_id
157: AND A.RESULT_TABLE = 'SO_LINES'
158: AND R.RESULT_ID = L.S27

Line 157: AND A.RESULT_TABLE = 'SO_LINES'

153: SO_RESULTS R,
154: SO_LINES L
155: WHERE
156: L.LINE_ID = x_line_id
157: AND A.RESULT_TABLE = 'SO_LINES'
158: AND R.RESULT_ID = L.S27
159: AND A.RESULT_COLUMN = 'S27';
160:
161: IF x_s27 = 0 THEN