[Home] [Help]
229: --ER 6135714 SELECT /* MOAC_SQL_NO_CHANGE */ l.line_id, l.line_number
230: SELECT /* MOAC_SQL_NO_CHANGE */ l.line_id, l.line_number,0 line_total --ER 6135714
231: FROM oe_order_lines_all l,
232: oe_order_headers_all h,
233: ra_terms_b t
234: WHERE l.invoice_to_org_id = p_site_use_id
235: AND l.header_id = p_header_id
236: AND h.header_id = l.header_id
237: AND l.open_flag = 'Y'
262: l2.ato_line_id = l.line_id and l2.ato_line_id <> l2.line_id)
263: )line_total
264: FROM oe_order_lines_all l,
265: oe_order_headers_all h,
266: ra_terms_b t
267: WHERE l.invoice_to_org_id = p_site_use_id
268: AND l.header_id = p_header_id
269: AND h.header_id = l.header_id
270: AND l.open_flag = 'Y'
294: l2.ato_line_id = l.line_id and l2.ato_line_id <> l2.line_id)
295: ) line_total
296: FROM oe_order_lines_all l,
297: oe_order_headers_all h,
298: ra_terms_b t
299: WHERE l.invoice_to_org_id = p_site_use_id
300: AND l.header_id = p_header_id
301: AND h.header_id = l.header_id
302: AND l.open_flag = 'Y'
325: l2.ato_line_id = l.line_id and l2.ato_line_id <> l2.line_id)
326: ) line_total
327: FROM oe_order_lines_all l,
328: oe_order_headers_all h,
329: ra_terms_b t
330: WHERE l.invoice_to_org_id = p_site_use_id
331: AND l.header_id = p_header_id
332: AND h.header_id = l.header_id
333: AND l.open_flag = 'Y'
356: l2.ato_line_id = l.line_id and l2.ato_line_id <> l2.line_id)
357: ) line_total
358: FROM oe_order_lines_all l,
359: oe_order_headers_all h,
360: ra_terms_b t
361: WHERE l.invoice_to_org_id = p_site_use_id
362: AND l.header_id = p_header_id
363: AND h.header_id = l.header_id
364: AND l.open_flag = 'Y'
3838: CURSOR lines_on_hold IS
3839: SELECT l.line_id, l.line_number
3840: FROM oe_order_headers_all h,
3841: oe_order_lines_all l,
3842: ra_terms t
3843: WHERE h.header_id = p_header_rec.header_id
3844: AND h.header_id = l.header_id
3845: AND l.payment_term_id = t.term_id
3846: AND nvl(t.credit_check_flag, 'N') = 'N'