DBA Data[Home] [Help]

APPS.GME_COMPLETE_BATCH_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 892: l_item_no mtl_system_items_kfv.concatenated_segments%TYPE;

888: l_prim_qty NUMBER;
889: l_prim_uom VARCHAR2(3);
890: l_from_um VARCHAR2(3);
891: l_to_um VARCHAR2(3);
892: l_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
893:
894: um_convert_error EXCEPTION;
895:
896: CURSOR item_no_cursor(v_inventory_item_id NUMBER,

Line 899: FROM mtl_system_items_kfv

895:
896: CURSOR item_no_cursor(v_inventory_item_id NUMBER,
897: v_org_id NUMBER) IS
898: SELECT concatenated_segments, primary_uom_code
899: FROM mtl_system_items_kfv
900: WHERE inventory_item_id = v_inventory_item_id
901: AND organization_id = v_org_id;
902:
903: error_build_mmti EXCEPTION;