APPS.GMF_LOT_COSTING_PUB dependencies on MTL_ITEM_FLEXFIELDS

Line 577: l_item_id mtl_item_flexfields.inventory_item_id%TYPE;

573: k PLS_INTEGER;
574: l PLS_INTEGER;
575:
576: dummy NUMBER;
577: l_item_id mtl_item_flexfields.inventory_item_id%TYPE;
578: l_batchstep_id NUMBER;
579: l_total_qty NUMBER;
580: TYPE num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
581: TYPE char_tab IS TABLE OF VARCHAR2(80) INDEX BY VARCHAR2(80); /* INVCONV sschinch */

Line 611: TYPE lot_uncostable_lots_tab IS TABLE OF mtl_item_flexfields.inventory_item_id%TYPE INDEX BY VARCHAR2(150);

607:
608: /*l_uncostable_lots_tab num_tab; INVCONV sschinch*/
609: /*l_uncostable_lots_tab char_tab; jboppana */
610:
611: TYPE lot_uncostable_lots_tab IS TABLE OF mtl_item_flexfields.inventory_item_id%TYPE INDEX BY VARCHAR2(150);
612: l_uncostable_lots_tab lot_uncostable_lots_tab;
613:
614:
615: l_cost_alloc_profile NUMBER; -- Bug 4057323

Line 639: TYPE lot_costed_items_tab IS TABLE OF mtl_item_flexfields.inventory_item_id%TYPE INDEX BY VARCHAR2(64);

635: l_acquisitions_total NUMBER;
636:
637: l_onhand_qty NUMBER;
638: -- umoogala
639: TYPE lot_costed_items_tab IS TABLE OF mtl_item_flexfields.inventory_item_id%TYPE INDEX BY VARCHAR2(64);
640: lc_items_tab lot_costed_items_tab;
641:
642: -- WHO columns -- umoogala 05-Dec-2003
643: l_user_id fnd_user.user_id%TYPE;

Line 4716: SELECT item_number INTO l_item_no FROM mtl_item_flexfields

4712: BEGIN
4713: procedure_name := 'Lot Cost Audit';
4714:
4715: -- Retrieve data in a form that the user will understand
4716: SELECT item_number INTO l_item_no FROM mtl_item_flexfields
4717: WHERE inventory_item_id = p_item_id AND organization_id = p_orgn_id;
4718:
4719: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||procedure_name);
4720: fnd_file.put_line