DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on MTL_UNITS_OF_MEASURE_TL

Line 97: TYPE uom_tab IS TABLE OF MTL_UNITS_OF_MEASURE_TL.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;

93: TYPE date_tab IS TABLE OF DATE 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;

Line 9472: l_mol_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE; --MOL uom code

9468: l_mol_qty NUMBER; --MOL quantity
9469: l_mol_qty_detailed NUMBER; --MOL total allocated quantity
9470: l_mol_qty_delivered NUMBER; --MOL transacted quantity
9471: l_new_txn_header_id NUMBER; --New value for transaction_header_id
9472: l_mol_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE; --MOL uom code
9473: l_tmp_qty1 NUMBER; --MOL Qty - MOL Delivered Qty
9474: l_tmp_prm_qty NUMBER; --MOL Qty - Delivered Qty in primary uom
9475: l_lpn_controlled_flag NUMBER; --LPN controlled flag for the drop sub
9476: l_qty_to_split NUMBER; --Quantity to split

Line 9478: l_grp_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE;

9474: l_tmp_prm_qty NUMBER; --MOL Qty - Delivered Qty in primary uom
9475: l_lpn_controlled_flag NUMBER; --LPN controlled flag for the drop sub
9476: l_qty_to_split NUMBER; --Quantity to split
9477: l_uom_con_sug_grp_qty NUMBER; --Suggested quantity converted to primary UOM???
9478: l_grp_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE;
9479: l_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE;
9480: l_primary_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE;
9481: l_serialized_item BOOLEAN; --Flag to indicate if the item is serialized
9482: l_group_id NUMBER; -- Group ID

Line 9479: l_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE;

9475: l_lpn_controlled_flag NUMBER; --LPN controlled flag for the drop sub
9476: l_qty_to_split NUMBER; --Quantity to split
9477: l_uom_con_sug_grp_qty NUMBER; --Suggested quantity converted to primary UOM???
9478: l_grp_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE;
9479: l_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE;
9480: l_primary_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE;
9481: l_serialized_item BOOLEAN; --Flag to indicate if the item is serialized
9482: l_group_id NUMBER; -- Group ID
9483: l_product_transaction_id NUMBER; --Product transaction id for complete_putaway

Line 9480: l_primary_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE;

9476: l_qty_to_split NUMBER; --Quantity to split
9477: l_uom_con_sug_grp_qty NUMBER; --Suggested quantity converted to primary UOM???
9478: l_grp_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE;
9479: l_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE;
9480: l_primary_uom_code MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE;
9481: l_serialized_item BOOLEAN; --Flag to indicate if the item is serialized
9482: l_group_id NUMBER; -- Group ID
9483: l_product_transaction_id NUMBER; --Product transaction id for complete_putaway
9484: l_item_id NUMBER; --Item ID for complete_putaway