eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 232: oe_order_headers_all h,

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

Line 265: oe_order_headers_all h,

261: + 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
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

Line 297: oe_order_headers_all h,

293: + 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
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

Line 328: oe_order_headers_all h,

324: + 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
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

Line 359: oe_order_headers_all h,

355: + 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
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

Line 3840: FROM oe_order_headers_all h,

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