APPS.WIP_MOVPROC_PRIV dependencies on MTL_LOT_NUMBERS

Line 8903: /* Use expiration date in MTL_LOT_NUMBERS. */

8899: x_returnStatus => l_returnStatus);
8900: END IF;
8901:
8902: /* Update lot records with an expiration date */
8903: /* Use expiration date in MTL_LOT_NUMBERS. */
8904: /* IF no expiration date THEN calculate based on SHELF_LIFE_DAYS */
8905:
8906: UPDATE mtl_transaction_lots_interface mtli
8907: SET lot_expiration_date =

Line 8911: mtl_lot_numbers mln

8907: SET lot_expiration_date =
8908: (SELECT MIN(mln.expiration_date)
8909: FROM mtl_transactions_interface mti,
8910: mtl_system_items msi,
8911: mtl_lot_numbers mln
8912: WHERE mti.organization_id = msi.organization_id
8913: AND mti.inventory_item_id = msi.inventory_item_id
8914: AND mti.transaction_header_id = p_gib.assy_header_id
8915: AND mti.transaction_action_id = l_txn_action_id

Line 8948: /* IF Exp date null in MTL_LOT_NUMBERS should I leave it null */

8944: wip_logger.log(p_msg => l_msg,
8945: x_returnStatus => l_returnStatus);
8946: END IF;
8947:
8948: /* IF Exp date null in MTL_LOT_NUMBERS should I leave it null */
8949: /* Or should I just decode based on exp date null in the temp table? */
8950: /* Removed group by and modIFied select and where conditions to avoid
8951: oracle error 1427. See bugs 866408 and 938422. */
8952: UPDATE mtl_transaction_lots_interface mtli