APPS.CSP_MINMAX_PVT dependencies on MTL_CATEGORIES

Line 23: , category_id mtl_categories.category_id%TYPE

19: , buying_lead_time mtl_system_items.full_lead_time%TYPE
20: , planner mtl_system_items.planner_code%TYPE
21: , buyer per_all_people_f.full_name%TYPE
22: , category VARCHAR2(800)
23: , category_id mtl_categories.category_id%TYPE
24: , item_id mtl_system_items.inventory_item_id%TYPE
25: , lot_ctl mtl_system_items.lot_control_code%TYPE
26: , repetitive_planned_item mtl_system_items.repetitive_planning_flag%TYPE
27: , primary_uom mtl_system_items.primary_uom_code%TYPE

Line 307: FROM mtl_categories b,

303: c.list_price_per_unit unit_price,
304: c.planning_make_buy_code mbf,
305: build_in_wip_flag build_in_wip,
306: pick_components_flag pick_components
307: FROM mtl_categories b,
308: mtl_item_categories a,
309: mtl_system_items c,
310: mtl_parameters p
311: WHERE b.category_id = a.category_id

Line 384: FROM mtl_categories b,

380: c.list_price_per_unit,
381: c.planning_make_buy_code,
382: build_in_wip_flag,
383: pick_components_flag
384: FROM mtl_categories b,
385: mtl_item_categories a,
386: mtl_system_items c,
387: mtl_parameters p,
388: mtl_secondary_inventories m,

Line 445: FROM mtl_categories b,

441: c.list_price_per_unit,
442: c.planning_make_buy_code,
443: build_in_wip_flag,
444: pick_components_flag
445: FROM mtl_categories b,
446: mtl_item_categories a,
447: mtl_system_items c,
448: mtl_parameters p,
449: per_all_people_f v

Line 530: FROM mtl_categories b,

526: c.list_price_per_unit,
527: c.planning_make_buy_code,
528: build_in_wip_flag,
529: pick_components_flag
530: FROM mtl_categories b,
531: mtl_item_categories a,
532: mtl_system_items c,
533: mtl_parameters p,
534: mtl_secondary_inventories m,

Line 884: FROM mtl_categories_kfv

880: , p_struct_id NUMBER) RETURN VARCHAR2 IS
881:
882: CURSOR c_catg_disp IS
883: SELECT concatenated_segments
884: FROM mtl_categories_kfv
885: WHERE category_id = p_category_id
886: AND structure_id = p_struct_id;
887:
888: c_catg_rec c_catg_disp%ROWTYPE;