APPS.OEXPURGE dependencies on SO_LINES

Line 237: FROM so_lines sl1,

233: p_order_type_name VARCHAR2 ) RETURN NUMBER IS
234:
235: CURSOR SO_PROBLEM_CHECK IS
236: SELECT 'Open return for this sales order'
237: FROM so_lines sl1,
238: so_lines sl2,
239: so_headers sh,
240: so_order_types ot
241: WHERE sh.order_number = p_order_number

Line 238: so_lines sl2,

234:
235: CURSOR SO_PROBLEM_CHECK IS
236: SELECT 'Open return for this sales order'
237: FROM so_lines sl1,
238: so_lines sl2,
239: so_headers sh,
240: so_order_types ot
241: WHERE sh.order_number = p_order_number
242: AND sh.order_type_id = ot.order_type_id

Line 695: FROM so_lines

691: v_line_id NUMBER := 0;
692:
693: CURSOR purge_lines IS
694: SELECT DISTINCT line_id -- Select the unique line_ids to be purged
695: FROM so_lines
696: WHERE header_id = p_header_id;
697: BEGIN
698: OPEN purge_lines;
699:

Line 708: FROM so_lines

704: OR purge_lines%NOTFOUND IS NULL; -- empty cursor
705:
706: SELECT line_id
707: INTO syntax_required
708: FROM so_lines
709: WHERE line_id = v_line_id
710: FOR UPDATE NOWAIT;
711:
712: return_status := so_purge_line_details( v_line_id,

Line 731: DELETE FROM so_lines

727: p_request_id );
728: END IF;
729:
730: IF return_status > -1 THEN
731: DELETE FROM so_lines
732: WHERE line_id = v_line_id;
733: ELSE
734: EXIT; -- abort additional processing
735: END IF;

Line 749: 'OEPUR: SO_LINES',

745: ROLLBACK;
746: so_record_errors( return_status,
747: p_request_id,
748: v_line_id,
749: 'OEPUR: SO_LINES',
750: NULL );
751: CLOSE purge_lines;
752: RETURN return_status;
753:

Line 1334: FROM so_picking_lines spl, so_lines sl

1330: v_picking_line_id NUMBER := 0;
1331:
1332: CURSOR purge_backorder_lines IS
1333: SELECT picking_line_id
1334: FROM so_picking_lines spl, so_lines sl
1335: WHERE spl.picking_header_id = -1
1336: AND sl.line_id = spl.order_line_id
1337: AND sl.header_id = p_header_id;
1338: BEGIN