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.

[Home] [Help]

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on OE_ORDER_LINES_ALL

Line 231: FROM oe_order_lines_all l,

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

Line 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

257:
258: --ER 6135714
259: CURSOR billto_lines_csr_2 IS
260: SELECT l.line_id, l.line_number , NVL(unit_selling_price,0) * NVL(ordered_quantity,0)
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,

Line 264: FROM oe_order_lines_all l,

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

Line 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

289:
290:
291: CURSOR billto_lines_csr_3 IS
292: SELECT l.line_id, l.line_number , NVL(unit_selling_price,0) * NVL(ordered_quantity,0)
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,

Line 296: FROM oe_order_lines_all l,

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

Line 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

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

Line 327: FROM oe_order_lines_all l,

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

Line 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

351: ORDER BY line_total asc;
352:
353: CURSOR billto_lines_csr_5 IS
354: SELECT l.line_id, l.line_number , NVL(unit_selling_price,0) * NVL(ordered_quantity,0)
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,

Line 358: FROM oe_order_lines_all l,

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

Line 3826: FROM oe_order_lines_all ool

3822:
3823: CURSOR cust_and_site_csr IS
3824: SELECT DISTINCT
3825: ool.invoice_to_org_id site_use_id
3826: FROM oe_order_lines_all ool
3827: WHERE ool.header_id = p_header_rec.header_id
3828: AND ool.open_flag = 'Y'
3829: AND NVL(ool.invoiced_quantity,0) = 0
3830: AND NVL(ool.shipped_quantity,0) = 0

Line 3841: oe_order_lines_all l,

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