19: select
20: nvl(l.selling_price,0),
21: SHPBKLOG.BACKLOG_QTY(l.line_id, l.item_type_code)
22: from
23: so_lines l
24: where
25: l.header_id = a_header_id and
26: l.line_type_code <> 'PARENT';
27:
140: into
141: ORDERED_QTY,
142: CANCELLED_QTY
143: from
144: so_lines
145: where
146: line_id = O_LINE_ID;
147:
148:
198: dummy
199: from
200: so_picking_headers ph,
201: so_picking_lines pl,
202: so_lines child,
203: so_lines parent
204: where
205: parent.line_id = O_LINE_ID and
206: child.parent_line_id = parent.line_id and
199: from
200: so_picking_headers ph,
201: so_picking_lines pl,
202: so_lines child,
203: so_lines parent
204: where
205: parent.line_id = O_LINE_ID and
206: child.parent_line_id = parent.line_id and
207: child.line_id = pl.order_line_id and
223: MODEL_CLASS_BACK_QTY
224: from
225: so_picking_lines pl,
226: so_picking_headers ph,
227: so_lines child,
228: so_lines parent
229: where
230: parent.line_id = O_LINE_ID and
231: child.parent_line_id = parent.line_id and
224: from
225: so_picking_lines pl,
226: so_picking_headers ph,
227: so_lines child,
228: so_lines parent
229: where
230: parent.line_id = O_LINE_ID and
231: child.parent_line_id = parent.line_id and
232: child.line_id = pl.order_line_id and