APPS.OE_ORDER_PURGE_PVT dependencies on OE_ORDER_LINES

Line 1410: oe_order_lines l

1406:
1407: select count(*)
1408: into l_cnt
1409: from wsh_delivery_details dd,
1410: oe_order_lines l
1411: where l.header_id = p_header_id
1412: and dd.source_line_id = l.line_id
1413: AND dd.org_id = l.org_id
1414: and dd.source_code = 'OE'

Line 1913: --FROM oe_order_lines sl1,

1909:
1910: CURSOR c_open_returns IS
1911: SELECT 'Open return for this sales order'
1912: /*MOAC*/
1913: --FROM oe_order_lines sl1,
1914: --oe_order_lines sl2,
1915: FROM oe_order_lines_all sl1,
1916: oe_order_lines_all sl2,
1917: oe_order_headers_all sh,

Line 1914: --oe_order_lines sl2,

1910: CURSOR c_open_returns IS
1911: SELECT 'Open return for this sales order'
1912: /*MOAC*/
1913: --FROM oe_order_lines sl1,
1914: --oe_order_lines sl2,
1915: FROM oe_order_lines_all sl1,
1916: oe_order_lines_all sl2,
1917: oe_order_headers_all sh,
1918: oe_order_types_v ot --MOAC view based on multiple objects

Line 1915: FROM oe_order_lines_all sl1,

1911: SELECT 'Open return for this sales order'
1912: /*MOAC*/
1913: --FROM oe_order_lines sl1,
1914: --oe_order_lines sl2,
1915: FROM oe_order_lines_all sl1,
1916: oe_order_lines_all sl2,
1917: oe_order_headers_all sh,
1918: oe_order_types_v ot --MOAC view based on multiple objects
1919: WHERE sh.order_number = p_order_number

Line 1916: oe_order_lines_all sl2,

1912: /*MOAC*/
1913: --FROM oe_order_lines sl1,
1914: --oe_order_lines sl2,
1915: FROM oe_order_lines_all sl1,
1916: oe_order_lines_all sl2,
1917: oe_order_headers_all sh,
1918: oe_order_types_v ot --MOAC view based on multiple objects
1919: WHERE sh.order_number = p_order_number
1920: AND sh.order_type_id = ot.order_type_id

Line 1958: FROM oe_order_lines

1954: x_message OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1955: IS
1956: CURSOR c_return_lines IS
1957: SELECT line_id
1958: FROM oe_order_lines
1959: WHERE header_id = p_header_id
1960: AND line_category_code = 'RETURN';
1961: l_line_id NUMBER;
1962: l_return_status varchar2(10);

Line 2420: FROM oe_order_lines

2416: SELECT line_id,order_quantity_uom,
2417: org_id,line_category_code,source_type_code,
2418: top_model_line_id,config_header_id,
2419: config_rev_nbr
2420: FROM oe_order_lines
2421: WHERE header_id = p_header_id;
2422:
2423: CURSOR c_purge_lines_hist IS
2424: SELECT line_id

Line 2425: FROM oe_order_lines_history

2421: WHERE header_id = p_header_id;
2422:
2423: CURSOR c_purge_lines_hist IS
2424: SELECT line_id
2425: FROM oe_order_lines_history
2426: WHERE header_id = p_header_id
2427: FOR UPDATE NOWAIT;
2428:
2429: CURSOR c_purge_ds IS

Line 2455: FROM oe_order_lines

2451: OR c_purge_lines%NOTFOUND IS NULL; -- empty cursor
2452:
2453: SELECT line_id
2454: INTO l_lock_line_id
2455: FROM oe_order_lines
2456: WHERE line_id = l_line_id
2457: FOR UPDATE NOWAIT;
2458:
2459: --IF condition added for bug 3664878

Line 2621: DELETE FROM oe_order_lines_history WHERE header_id = p_header_id;

2617: -- Purge the History tables
2618:
2619: OPEN c_purge_lines_hist;
2620: CLOSE c_purge_lines_hist;
2621: DELETE FROM oe_order_lines_history WHERE header_id = p_header_id;
2622:
2623: OE_DEBUG_PUB.Add('Before line delete : ',1);
2624:
2625: DELETE FROM oe_order_lines

Line 2625: DELETE FROM oe_order_lines

2621: DELETE FROM oe_order_lines_history WHERE header_id = p_header_id;
2622:
2623: OE_DEBUG_PUB.Add('Before line delete : ',1);
2624:
2625: DELETE FROM oe_order_lines
2626: WHERE line_id = l_line_id;
2627:
2628: END LOOP;
2629:

Line 2695: ,'ORDPUR: OE_ORDER_LINES '||substr(sqlerrm,1,200)

2691: ROLLBACK TO SAVEPOINT ORDER_HEADER;
2692: record_errors( l_return_status
2693: ,p_purge_set_id
2694: ,p_header_id
2695: ,'ORDPUR: OE_ORDER_LINES '||substr(sqlerrm,1,200)
2696: );
2697: CLOSE c_purge_lines;
2698:
2699: END Oe_Purge_Lines;

Line 3777: oe_order_lines l

3773:
3774: SELECT count(*)
3775: INTO l_cnt
3776: FROM wsh_delivery_details dd,
3777: oe_order_lines l
3778: WHERE l.header_id = p_header_id
3779: AND dd.source_line_id = l.line_id
3780: AND dd.org_id = l.org_id
3781: AND dd.source_code = 'OE'