[Home] [Help]
263: --ER 6135714 SELECT /* MOAC_SQL_NO_CHANGE */ l.line_id, l.line_number
264: SELECT /* MOAC_SQL_NO_CHANGE */ l.line_id, l.line_number,0 line_total --ER 6135714
265: FROM oe_order_lines_all l,
266: oe_order_headers_all h,
267: ra_terms_b t
268: WHERE l.invoice_to_org_id = p_site_use_id
269: AND l.header_id = p_header_id
270: AND h.header_id = l.header_id
271: AND l.open_flag = 'Y'
296: l2.ato_line_id = l.line_id and l2.ato_line_id <> l2.line_id)
297: )line_total
298: FROM oe_order_lines_all l,
299: oe_order_headers_all h,
300: ra_terms_b t
301: WHERE l.invoice_to_org_id = p_site_use_id
302: AND l.header_id = p_header_id
303: AND h.header_id = l.header_id
304: AND l.open_flag = 'Y'
328: l2.ato_line_id = l.line_id and l2.ato_line_id <> l2.line_id)
329: ) line_total
330: FROM oe_order_lines_all l,
331: oe_order_headers_all h,
332: ra_terms_b t
333: WHERE l.invoice_to_org_id = p_site_use_id
334: AND l.header_id = p_header_id
335: AND h.header_id = l.header_id
336: AND l.open_flag = 'Y'
359: l2.ato_line_id = l.line_id and l2.ato_line_id <> l2.line_id)
360: ) line_total
361: FROM oe_order_lines_all l,
362: oe_order_headers_all h,
363: ra_terms_b t
364: WHERE l.invoice_to_org_id = p_site_use_id
365: AND l.header_id = p_header_id
366: AND h.header_id = l.header_id
367: AND l.open_flag = 'Y'
390: l2.ato_line_id = l.line_id and l2.ato_line_id <> l2.line_id)
391: ) line_total
392: FROM oe_order_lines_all l,
393: oe_order_headers_all h,
394: ra_terms_b t
395: WHERE l.invoice_to_org_id = p_site_use_id
396: AND l.header_id = p_header_id
397: AND h.header_id = l.header_id
398: AND l.open_flag = 'Y'
4262: CURSOR lines_on_hold IS
4263: SELECT l.line_id, l.line_number
4264: FROM oe_order_headers_all h,
4265: oe_order_lines_all l,
4266: ra_terms t
4267: WHERE h.header_id = p_header_rec.header_id
4268: AND h.header_id = l.header_id
4269: AND l.payment_term_id = t.term_id
4270: AND nvl(t.credit_check_flag, 'N') = 'N'