APPS.WMS_PUTAWAY_UTILS dependencies on MTL_LOT_NUMBERS

Line 98: TYPE lot_tab IS TABLE OF MTL_LOT_NUMBERS.LOT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

94: TYPE rowid_tab IS TABLE OF urowid INDEX BY BINARY_INTEGER;
95: TYPE varchar240_tab IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
96:
97: TYPE uom_tab IS TABLE OF MTL_UNITS_OF_MEASURE_TL.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE lot_tab IS TABLE OF MTL_LOT_NUMBERS.LOT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
99: TYPE rev_tab IS TABLE OF MTL_ITEM_REVISIONS.REVISION%TYPE INDEX BY BINARY_INTEGER;
100:
101: TYPE entity_tab IS TABLE OF WIP_ENTITIES.WIP_ENTITY_NAME%TYPE INDEX BY BINARY_INTEGER;
102: TYPE line_tab IS TABLE OF WIP_LINES.LINE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 9491: l_lot_number mtl_lot_numbers.lot_number%type; --p_lot for complete_putaway

9487: l_lpn_id NUMBER; --p_LPN_ID for complete_putaway???--check
9488: l_to_lpn_id NUMBER; --To LPN ID -- for pack/unpack
9489: l_to_lpn_name wms_license_plate_numbers.license_plate_number%TYPE;
9490: l_revision mtl_item_revisions.revision%TYPE; --p_rev for complete_putaway
9491: l_lot_number mtl_lot_numbers.lot_number%type; --p_lot for complete_putaway
9492: l_mmtt_prm_qty NUMBER; --Lot quantity in primary uom
9493: l_lot_expiration_date DATE; --Lot expiration date
9494: l_lot_status_id NUMBER; --Lot Status
9495: l_cur_ser_number mtl_serial_numbers.serial_number%TYPE;

Line 10556: FROM mtl_lot_numbers

10552: SELECT expiration_date
10553: , status_id
10554: INTO l_lot_expiration_date
10555: , l_lot_status_id
10556: FROM mtl_lot_numbers
10557: WHERE lot_number = p_lot_number
10558: AND inventory_item_id = p_item_id
10559: AND organization_id = p_organization_id;
10560: