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 1722: FROM mtl_system_items msi

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

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;

Line 2055: FROM mtl_system_items

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

Line 2408: from mtl_system_items

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