APPS.INV_MINMAX_PVT dependencies on MTL_CATEGORIES

Line 28: , category_id mtl_categories.category_id%TYPE

24: , buying_lead_time mtl_system_items.full_lead_time%TYPE
25: , planner mtl_system_items.planner_code%TYPE
26: , buyer per_all_people_f.full_name%TYPE
27: , category VARCHAR2(800)
28: , category_id mtl_categories.category_id%TYPE
29: , item_id mtl_system_items.inventory_item_id%TYPE
30: , lot_ctl mtl_system_items.lot_control_code%TYPE
31: , repetitive_planned_item mtl_system_items.repetitive_planning_flag%TYPE
32: , primary_uom mtl_system_items.primary_uom_code%TYPE

Line 323: FROM mtl_categories b,

319: NVL(c.recipe_enabled_flag,''N'') recipe_enabled,
320: NVL(c.process_execution_enabled_flag,''N'') execution_enabled,
321: /* nsinghi MIN-MAX INVCONV end */
322: pick_components_flag pick_components
323: FROM mtl_categories b,
324: mtl_item_categories a,
325: mtl_system_items_vl c,
326: mtl_parameters p
327: WHERE b.category_id = a.category_id

Line 405: FROM mtl_categories b,

401: NVL(c.recipe_enabled_flag,''N'') recipe_enabled,
402: NVL(c.process_execution_enabled_flag,''N'') execution_enabled,
403: /* nsinghi MIN-MAX INVCONV end */
404: pick_components_flag
405: FROM mtl_categories b,
406: mtl_item_categories a,
407: mtl_system_items_vl c,
408: mtl_parameters p,
409: mtl_secondary_inventories m,

Line 471: FROM mtl_categories b,

467: NVL(c.recipe_enabled_flag,''N'') recipe_enabled,
468: NVL(c.process_execution_enabled_flag,''N'') execution_enabled,
469: /* nsinghi MIN-MAX INVCONV end */
470: pick_components_flag
471: FROM mtl_categories b,
472: mtl_item_categories a,
473: mtl_system_items_vl c,
474: mtl_parameters p,
475: per_all_people_f v

Line 562: FROM mtl_categories b,

558: NVL(c.recipe_enabled_flag,''N'') recipe_enabled,
559: NVL(c.process_execution_enabled_flag,''N'') execution_enabled,
560: /* nsinghi MIN-MAX INVCONV end */
561: pick_components_flag
562: FROM mtl_categories b,
563: mtl_item_categories a,
564: mtl_system_items_vl c,
565: mtl_parameters p,
566: mtl_secondary_inventories m,

Line 942: FROM mtl_categories_kfv

938: , p_struct_id NUMBER) RETURN VARCHAR2 IS
939:
940: CURSOR c_catg_disp IS
941: SELECT concatenated_segments
942: FROM mtl_categories_kfv
943: WHERE category_id = p_category_id
944: AND structure_id = p_struct_id;
945:
946: c_catg_rec c_catg_disp%ROWTYPE;