APPS.INV_LOT_API_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 610: FROM mtl_system_items_b

606: , retest_interval
607: , maturity_days
608: , hold_days
609: , default_lot_status_id --bug10257769
610: FROM mtl_system_items_b
611: WHERE organization_id = cp_organization_id
612: AND inventory_item_id = cp_inventory_item_id;
613:
614: -- nsinghi bug#5209065 rework START. If existing lot,

Line 971: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;

967: user_defined_exp_date CONSTANT NUMBER := 4;
968: l_mtl_gen_obj_no NUMBER ;
969:
970: /*Program variables declaration */
971: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
972: l_chk_lot_uniqueness BOOLEAN;
973: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
974: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
975: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;