DBA Data[Home] [Help]

APPS.CSP_PLANNER_NOTIFICATIONS dependencies on MTL_SYSTEM_ITEMS_KFV

Line 222: FROM mtl_system_items_kfv c,

218: c.inventory_item_id item_id,
219: c.planner_code planner,
220: build_in_wip_flag build_in_wip,
221: pick_components_flag pick_components
222: FROM mtl_system_items_kfv c,
223: mtl_parameters p
224: WHERE c.concatenated_segments = p_item_Segments
225: AND c.organization_id = p.organization_id
226: AND p.organization_id = p_organization_id;

Line 845: FROM mtl_system_items_kfv msik

841: SELECT msik.planner_code,
842: msik.inventory_item_id
843: INTO l_planner,
844: l_item_id
845: FROM mtl_system_items_kfv msik
846: WHERE msik.concatenated_segments = mrc.item_segments
847: AND msik.organization_id = p_organization_id;
848:
849: -- check if item is on a suppressed notification

Line 1157: FROM mtl_system_items_kfv c,

1153: c.planning_make_buy_code mbf,
1154: c.planner_code planner,
1155: build_in_wip_flag build_in_wip,
1156: pick_components_flag pick_components
1157: FROM mtl_system_items_kfv c,
1158: mtl_parameters p
1159: WHERE c.inventory_item_id = p_item_id
1160: AND c.organization_id = p.organization_id
1161: AND p.organization_id = p_organization_id;

Line 2012: FROM mtl_system_items_kfv

2008:
2009: Begin
2010: SELECT concatenated_segments
2011: INTO l_item
2012: FROM mtl_system_items_kfv
2013: WHERE inventory_item_id = p_item_rec.inventory_item_id;
2014: Exception
2015: WHEN OTHERS THEN
2016: null;