[Home] [Help]
433: k PLS_INTEGER;
434: l PLS_INTEGER;
435:
436: dummy NUMBER;
437: l_item_id mtl_item_flexfields.inventory_item_id%TYPE;
438: l_batchstep_id NUMBER;
439: l_total_qty NUMBER;
440: TYPE num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
441: TYPE char_tab IS TABLE OF VARCHAR2(80) INDEX BY VARCHAR2(80); /* INVCONV sschinch */
466:
467: /*l_uncostable_lots_tab num_tab; INVCONV sschinch*/
468: /*l_uncostable_lots_tab char_tab; jboppana */
469:
470: TYPE lot_uncostable_lots_tab IS TABLE OF mtl_item_flexfields.inventory_item_id%TYPE INDEX BY VARCHAR2(150);
471: l_uncostable_lots_tab lot_uncostable_lots_tab;
472:
473:
474: l_cost_alloc_profile NUMBER; -- Bug 4057323
494: l_acquisitions_total NUMBER;
495:
496: l_onhand_qty NUMBER;
497: -- umoogala
498: TYPE lot_costed_items_tab IS TABLE OF mtl_item_flexfields.inventory_item_id%TYPE INDEX BY VARCHAR2(64);
499: lc_items_tab lot_costed_items_tab;
500:
501: -- WHO columns -- umoogala 05-Dec-2003
502: l_user_id fnd_user.user_id%TYPE;
4057:
4058: -- Retrieve data in a form that the user will understand
4059:
4060:
4061: SELECT item_number INTO l_item_no FROM mtl_item_flexfields
4062: WHERE inventory_item_id = p_item_id AND organization_id = p_orgn_id;
4063:
4064:
4065: