APPS.SHPBKLOG dependencies on STANDARD

Line 73: STANDARD_II_BACK_QTY NUMBER := 0;

69: ORDERED_QTY NUMBER DEFAULT NULL;
70:
71: CANCELLED_QTY NUMBER DEFAULT NULL;
72: BACK_QTY NUMBER := 0;
73: STANDARD_II_BACK_QTY NUMBER := 0;
74: MODEL_CLASS_BACK_QTY NUMBER := 0;
75: DUMMY NUMBER;
76:
77: /* Assumptions:

Line 262: /* shippable standard lines and lines w/ shippable included items

258: RETURN(BACK_QTY);
259: END IF;
260: END IF;
261:
262: /* shippable standard lines and lines w/ shippable included items
263: which have been fully released */
264:
265: IF (ALL_SHIPPABLE_RELEASED = 'Y' AND SHIPPABLE = 'Y' AND SOMETHING_RELEASED = 'Y')
266: THEN

Line 273: STANDARD_II_BACK_QTY

269: ORDERED_QTY -
270: CANCELLED_QTY -
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

Line 286: IF STANDARD_II_BACK_QTY > BACK_QTY

282: pl.inventory_item_id;
283:
284: IF SQL%FOUND
285: THEN
286: IF STANDARD_II_BACK_QTY > BACK_QTY
287: THEN
288: BACK_QTY := STANDARD_II_BACK_QTY;
289: END IF;
290: END IF;

Line 288: BACK_QTY := STANDARD_II_BACK_QTY;

284: IF SQL%FOUND
285: THEN
286: IF STANDARD_II_BACK_QTY > BACK_QTY
287: THEN
288: BACK_QTY := STANDARD_II_BACK_QTY;
289: END IF;
290: END IF;
291:
292: ELSE /* unrepresented components */

Line 300: is a standard, then do not show as backlog. */

296:
297: END IF;
298:
299: /* If non-shippable and all the details are released and the item_type
300: is a standard, then do not show as backlog. */
301:
302: IF (SHIPPABLE = 'N' AND ALL_DETAILS_RELEASED = 'Y' AND
303: ITEM_TYPE_CODE IN ('STANDARD', 'KIT'))
304: THEN

Line 303: ITEM_TYPE_CODE IN ('STANDARD', 'KIT'))

299: /* If non-shippable and all the details are released and the item_type
300: is a standard, then do not show as backlog. */
301:
302: IF (SHIPPABLE = 'N' AND ALL_DETAILS_RELEASED = 'Y' AND
303: ITEM_TYPE_CODE IN ('STANDARD', 'KIT'))
304: THEN
305:
306: BACK_QTY := 0;
307: