DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 266: oe_order_headers_all h,

262: CURSOR billto_lines_csr_1 IS --ER 6135714
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

Line 299: oe_order_headers_all h,

295: + decode( l.ato_line_id, null , 0, (select sum (NVL(l2.unit_selling_price,0) * NVL(l2.ordered_quantity,0)) from oe_order_lines_all l2 where
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

Line 331: oe_order_headers_all h,

327: + decode( l.ato_line_id, null , 0, (select sum (NVL(l2.unit_selling_price,0) * NVL(l2.ordered_quantity,0)) from oe_order_lines_all l2 where
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

Line 362: oe_order_headers_all h,

358: + decode( l.ato_line_id, null , 0, (select sum (NVL(l2.unit_selling_price,0) * NVL(l2.ordered_quantity,0)) from oe_order_lines_all l2 where
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

Line 393: oe_order_headers_all h,

389: + decode( l.ato_line_id, null , 0, (select sum (NVL(l2.unit_selling_price,0) * NVL(l2.ordered_quantity,0)) from oe_order_lines_all l2 where
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

Line 4264: FROM oe_order_headers_all h,

4260: -- credit check flag unchecked, this might be resulted by user changing
4261: -- the payment term after hold got applied.
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