APPS.INV_LOT_API_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 569: FROM mtl_system_items_b

565: , expiration_action_interval
566: , retest_interval
567: , maturity_days
568: , hold_days
569: FROM mtl_system_items_b
570: WHERE organization_id = cp_organization_id
571: AND inventory_item_id = cp_inventory_item_id;
572:
573: -- nsinghi bug#5209065 rework START. If existing lot,

Line 915: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;

911: user_defined_exp_date CONSTANT NUMBER := 4;
912: l_mtl_gen_obj_no NUMBER ;
913:
914: /*Program variables declaration */
915: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
916: l_chk_lot_uniqueness BOOLEAN;
917: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
918: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
919: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;