DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on MTL_ITEM_REVISIONS

Line 99: TYPE rev_tab IS TABLE OF MTL_ITEM_REVISIONS.REVISION%TYPE 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;
103: TYPE dept_tab IS TABLE OF BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 9490: l_revision mtl_item_revisions.revision%TYPE; --p_rev for complete_putaway

9486: l_locator_id NUMBER; --Locator 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