APPS.CSP_PLANNER_NOTIFICATIONS dependencies on MTL_SYSTEM_ITEMS

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 999: from mtl_system_items c

995: NVL(c.postprocessing_lead_time, 0) buying_lead_time
996: into l_fixed_lt,
997: l_Variable_lt,
998: l_buying_lt
999: from mtl_system_items c
1000: where c.inventory_item_id = onc.inventory_item_id
1001: and organization_id = p_organization_id;
1002:
1003: IF (onc.notification_type IN ('IO', 'PO')) THEN

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 1418: from mtl_system_items c,

1414: DECODE(p.source_type, NULL, NULL, p.source_subinventory),
1415: c.source_subinventory) src_subinv
1416: into l_parts_rec.source_org_id,
1417: l_parts_rec.source_subinv
1418: from mtl_system_items c,
1419: mtl_parameters p
1420: where c.inventory_item_id = l_parts_rec.inventory_item_id
1421: and c.organization_id = p.organization_id
1422: and p.organization_id = p_organization_id;

Line 1725: FROM mtl_system_items msi

1721: IF (p_pur_revision IS NULL)
1722: THEN
1723: SELECT MAX(revision_qty_control_code)
1724: INTO item_rev_ctl
1725: FROM mtl_system_items msi
1726: WHERE msi.organization_id = orgn_id
1727: AND msi.inventory_item_id = item_id;
1728: END IF ;
1729:

Line 2015: FROM mtl_system_items_kfv

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

Line 2058: FROM mtl_system_items

2054: -- Else, call Inventory API to calculate max.
2055: BEGIN
2056: SELECT inventory_planning_code
2057: INTO l_item_minmax_flag
2058: FROM mtl_system_items
2059: where organization_id = esc.source_organization_id
2060: and inventory_item_id = p_item_rec.inventory_item_id;
2061: EXCEPTION
2062: when no_data_found then

Line 2411: from mtl_system_items

2407: IF (rsc.source_type = 1) THEN
2408: BEGIN
2409: select serv_req_enabled_code
2410: into l_Serviceable
2411: from mtl_system_items
2412: where inventory_item_id = p_inventory_item_id
2413: and organization_id = rsc.source_organization_id;
2414: EXCEPTION
2415: when no_data_found then