DBA Data[Home] [Help]

APPS.CSP_PLANNER_NOTIFICATIONS dependencies on MTL_PARAMETERS

Line 223: mtl_parameters p

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;
227:

Line 331: from mtl_parameters p

327:
328: /* get calendar */
329: select p.calendar_code, p.calendar_exception_set_id
330: into l_cal_code, l_exception_set_id
331: from mtl_parameters p
332: where p.organization_id = p_organization_id;
333:
334: /* Validate cat set and MCAT struct */
335: IF (p_category_set_id is not null and p_category_struct_id is not null) then

Line 905: mtl_parameters mp

901: BEGIN
902: SELECT cic.item_cost
903: INTO l_item_cost
904: FROM cst_item_costs cic,
905: mtl_parameters mp
906: WHERE cic.inventory_item_id = l_item_id
907: AND cic.organization_id = mp.organization_id
908: AND cic.cost_type_id = mp.primary_cost_method
909: AND mp.organization_id = p_organization_id;

Line 1158: mtl_parameters p

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;
1162:

Line 1198: mtl_parameters mp

1194: begin
1195: SELECT cic.item_cost
1196: INTO l_item_cost
1197: FROM cst_item_costs cic,
1198: mtl_parameters mp
1199: WHERE cic.inventory_item_id = onc.inventory_item_id
1200: AND cic.organization_id = mp.organization_id
1201: AND cic.cost_type_id = mp.primary_cost_method
1202: AND mp.organization_id = p_organization_id;

Line 1419: mtl_parameters p

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;
1423: