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_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 2173: WHERE (entity_id,entity_number) IN (SELECT 2,line_id FROM oe_order_lines_all WHERE header_id=p_header_id)

2169:
2170: CURSOR c_lock_audit_hist_ent2 IS
2171: SELECT entity_id -- Lock all rows to be purged
2172: FROM OE_AUDIT_ATTR_HISTORY
2173: WHERE (entity_id,entity_number) IN (SELECT 2,line_id FROM oe_order_lines_all WHERE header_id=p_header_id)
2174: FOR UPDATE NOWAIT;
2175:
2176: CURSOR c_lock_audit_hist_ent6_8 IS
2177: SELECT entity_id -- Lock all rows to be purged

Line 2214: WHERE (entity_id,entity_number) IN (SELECT 2,line_id FROM oe_order_lines_all WHERE header_id=p_header_id);

2210: OPEN c_lock_audit_hist_ent2;
2211: CLOSE c_lock_audit_hist_ent2;
2212: DELETE
2213: FROM OE_AUDIT_ATTR_HISTORY
2214: WHERE (entity_id,entity_number) IN (SELECT 2,line_id FROM oe_order_lines_all WHERE header_id=p_header_id);
2215:
2216:
2217: OPEN c_lock_audit_hist_ent6_8;
2218: CLOSE c_lock_audit_hist_ent6_8;

Line 2474: FROM oe_order_lines

2470: SELECT line_id,order_quantity_uom,
2471: org_id,line_category_code,source_type_code,
2472: top_model_line_id,config_header_id,
2473: config_rev_nbr
2474: FROM oe_order_lines
2475: WHERE header_id = p_header_id;
2476:
2477: CURSOR c_purge_lines_hist IS
2478: SELECT line_id

Line 2479: FROM oe_order_lines_history

2475: WHERE header_id = p_header_id;
2476:
2477: CURSOR c_purge_lines_hist IS
2478: SELECT line_id
2479: FROM oe_order_lines_history
2480: WHERE header_id = p_header_id
2481: FOR UPDATE NOWAIT;
2482:
2483: CURSOR c_purge_ds IS

Line 2509: FROM oe_order_lines

2505: OR c_purge_lines%NOTFOUND IS NULL; -- empty cursor
2506:
2507: SELECT line_id
2508: INTO l_lock_line_id
2509: FROM oe_order_lines
2510: WHERE line_id = l_line_id
2511: FOR UPDATE NOWAIT;
2512:
2513: --IF condition added for bug 3664878

Line 2675: DELETE FROM oe_order_lines_history WHERE header_id = p_header_id;

2671: -- Purge the History tables
2672:
2673: OPEN c_purge_lines_hist;
2674: CLOSE c_purge_lines_hist;
2675: DELETE FROM oe_order_lines_history WHERE header_id = p_header_id;
2676:
2677: OE_DEBUG_PUB.Add('Before line delete : ',1);
2678:
2679: DELETE FROM oe_order_lines

Line 2679: DELETE FROM oe_order_lines

2675: DELETE FROM oe_order_lines_history WHERE header_id = p_header_id;
2676:
2677: OE_DEBUG_PUB.Add('Before line delete : ',1);
2678:
2679: DELETE FROM oe_order_lines
2680: WHERE line_id = l_line_id;
2681:
2682: END LOOP;
2683:

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

2745: ROLLBACK TO SAVEPOINT ORDER_HEADER;
2746: record_errors( l_return_status
2747: ,p_purge_set_id
2748: ,p_header_id
2749: ,'ORDPUR: OE_ORDER_LINES '||substr(sqlerrm,1,200)
2750: );
2751: CLOSE c_purge_lines;
2752:
2753: END Oe_Purge_Lines;

Line 3831: oe_order_lines l

3827:
3828: SELECT count(*)
3829: INTO l_cnt
3830: FROM wsh_delivery_details dd,
3831: oe_order_lines l
3832: WHERE l.header_id = p_header_id
3833: AND dd.source_line_id = l.line_id
3834: AND dd.org_id = l.org_id
3835: AND dd.source_code = 'OE'