APPS.INV_UTILITIES dependencies on MTL_PARAMETERS

Line 404: FROM MTL_PARAMETERS

400: IF (NVL(v_stock_enabled_flag, 'N') = 'Y' and NVL(v_inv_asset_flag,'N') = 'Y')
401: THEN
402: SELECT NVL(LCM_ENABLED_FLAG, 'N')
403: INTO v_lcm_enabled_flag
404: FROM MTL_PARAMETERS
405: WHERE ORGANIZATION_ID = p_ship_to_org_id;
406:
407: RETURN v_lcm_enabled_flag;
408: ELSE

Line 462: FROM mtl_parameters

458: WHERE id_flex_code = 'MTLL';
459:
460: SELECT project_reference_enabled
461: INTO v_proj_ref_enabled
462: FROM mtl_parameters
463: WHERE organization_id = x_org_id;
464:
465: v_delim := fnd_flex_ext.get_delimiter('INV', v_flex_code, v_flex_num);
466: str1 := '||''' || v_delim || '''||';

Line 604: FROM MTL_PARAMETERS mp

600: BEGIN
601: --Bug7037252/6349028/6343400. Added following SELECT
602: SELECT NVL(mp.wms_enabled_flag,'N')
603: INTO l_wms_enabled_flag
604: FROM MTL_PARAMETERS mp
605: WHERE mp.organization_id=v_org_id ;
606: SELECT NVL(ccicv.item_cost, 0)
607: INTO v_item_cost
608: FROM cst_cg_item_costs_view ccicv, mtl_parameters mp

Line 608: FROM cst_cg_item_costs_view ccicv, mtl_parameters mp

604: FROM MTL_PARAMETERS mp
605: WHERE mp.organization_id=v_org_id ;
606: SELECT NVL(ccicv.item_cost, 0)
607: INTO v_item_cost
608: FROM cst_cg_item_costs_view ccicv, mtl_parameters mp
609: WHERE v_locator_id IS NULL
610: AND ccicv.organization_id = v_org_id
611: AND ccicv.inventory_item_id = v_item_id
612: AND ccicv.organization_id = mp.organization_id

Line 616: FROM mtl_item_locations mil, cst_cg_item_costs_view ccicv, mtl_parameters mp

612: AND ccicv.organization_id = mp.organization_id
613: AND ccicv.cost_group_id = DECODE(mp.primary_cost_method, 1, 1, NVL(mp.default_cost_group_id, 1))
614: UNION ALL
615: SELECT NVL(ccicv.item_cost, 0)
616: FROM mtl_item_locations mil, cst_cg_item_costs_view ccicv, mtl_parameters mp
617: WHERE v_locator_id IS NOT NULL
618: AND mil.organization_id = v_org_id
619: AND mil.inventory_location_id = v_locator_id
620: AND mil.project_id IS NULL

Line 627: FROM mtl_item_locations mil, mrp_project_parameters mrp, cst_cg_item_costs_view ccicv, mtl_parameters mp

623: AND ccicv.organization_id = mp.organization_id
624: AND ccicv.cost_group_id = DECODE(mp.primary_cost_method, 1, 1, DECODE(l_wms_enabled_flag,'Y',ccicv.cost_group_id, NVL(mp.default_cost_group_id, 1)))
625: UNION ALL
626: SELECT NVL(ccicv.item_cost, 0)
627: FROM mtl_item_locations mil, mrp_project_parameters mrp, cst_cg_item_costs_view ccicv, mtl_parameters mp
628: WHERE v_locator_id IS NOT NULL
629: AND mil.organization_id = v_org_id
630: AND mil.inventory_location_id = v_locator_id
631: AND mil.project_id IS NOT NULL