APPS.SHPBKLOG dependencies on SO_PICKING_LINES

Line 151: lines is so_picking_lines */

147:
148:
149: /* if line is shippable and something was released
150: make sure that there are no unrepresented shippable
151: lines is so_picking_lines */
152:
153:
154: IF (SHIPPABLE = 'Y' and SOMETHING_RELEASED = 'Y')
155: then

Line 163: from so_picking_lines spl

159: where ld.line_id = O_LINE_ID
160: and ld.shippable_flag = 'Y'
161: and ld.inventory_item_id+0 in
162: (select distinct spl.inventory_item_id+0
163: from so_picking_lines spl
164: where spl.order_line_id = O_LINE_ID
165: and spl.picking_header_id+0 not in (0, -1));
166:
167: end if;

Line 201: so_picking_lines pl,

197: into
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

Line 225: so_picking_lines pl,

221: nvl(floor(min(sum(nvl(pl.shipped_quantity,0))/ max(pl.component_ratio))), 0)
222: into
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

Line 246: FROM SO_PICKING_LINES SPL

242: WHERE LD.LINE_ID = child.LINE_ID
243: AND LD.SHIPPABLE_FLAG = 'Y'
244: AND LD.INVENTORY_ITEM_ID+0 NOT IN
245: (SELECT DISTINCT SPL.INVENTORY_ITEM_ID+0
246: FROM SO_PICKING_LINES SPL
247: WHERE SPL.ORDER_LINE_ID = LD.LINE_ID
248: AND SPL.PICKING_HEADER_ID+0 NOT IN (0, -1)))
249: group by
250: pl.inventory_item_id;

Line 275: so_picking_lines pl,

271: nvl(floor(min(sum(nvl(pl.shipped_quantity,0)) / max(pl.component_ratio))), 0)
272: into
273: STANDARD_II_BACK_QTY
274: from
275: so_picking_lines pl,
276: so_picking_headers ph
277: where
278: pl.order_line_id = O_LINE_ID and
279: ph.picking_header_id = pl.picking_header_id and