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_LINES_ALL

Line 99: from oe_order_lines_all

95:
96: BEGIN
97: Select top_model_line_id
98: into l_top_model_line_id
99: from oe_order_lines_all
100: where line_id=p_line_id
101: and top_model_line_id IS NOT NULL
102: and ship_model_complete_flag='Y';
103:

Line 265: FROM oe_order_lines_all l,

261: --ER 6135714 CURSOR billto_lines_csr IS
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

Line 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

291:
292: --ER 6135714
293: CURSOR billto_lines_csr_2 IS
294: SELECT l.line_id, l.line_number , NVL(unit_selling_price,0) * NVL(ordered_quantity,0)
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,

Line 298: FROM oe_order_lines_all l,

294: SELECT l.line_id, l.line_number , NVL(unit_selling_price,0) * NVL(ordered_quantity,0)
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

Line 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

323:
324:
325: CURSOR billto_lines_csr_3 IS
326: SELECT l.line_id, l.line_number , NVL(unit_selling_price,0) * NVL(ordered_quantity,0)
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,

Line 330: FROM oe_order_lines_all l,

326: SELECT l.line_id, l.line_number , NVL(unit_selling_price,0) * NVL(ordered_quantity,0)
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

Line 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

354: ORDER BY l.SHIPMENT_PRIORITY_CODE,nvl(l.SCHEDULE_SHIP_DATE, l.REQUEST_DATE) , l.line_id;
355:
356: CURSOR billto_lines_csr_4 IS
357: SELECT l.line_id, l.line_number , NVL(unit_selling_price,0) * NVL(ordered_quantity,0)
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,

Line 361: FROM oe_order_lines_all l,

357: SELECT l.line_id, l.line_number , NVL(unit_selling_price,0) * NVL(ordered_quantity,0)
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

Line 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

385: ORDER BY line_total asc;
386:
387: CURSOR billto_lines_csr_5 IS
388: SELECT l.line_id, l.line_number , NVL(unit_selling_price,0) * NVL(ordered_quantity,0)
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,

Line 392: FROM oe_order_lines_all l,

388: SELECT l.line_id, l.line_number , NVL(unit_selling_price,0) * NVL(ordered_quantity,0)
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

Line 4250: FROM oe_order_lines_all ool

4246:
4247: CURSOR cust_and_site_csr IS
4248: SELECT DISTINCT
4249: ool.invoice_to_org_id site_use_id
4250: FROM oe_order_lines_all ool
4251: WHERE ool.header_id = p_header_rec.header_id
4252: AND ool.open_flag = 'Y'
4253: AND NVL(ool.invoiced_quantity,0) = 0
4254: AND NVL(ool.shipped_quantity,0) = 0

Line 4265: oe_order_lines_all l,

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
4269: AND l.payment_term_id = t.term_id