APPS.INV_UTILITIES dependencies on MTL_PARAMETERS

Line 458: FROM MTL_PARAMETERS

454: RETURN 'N';
455: ELSE
456: SELECT NVL(LCM_ENABLED_FLAG, 'N')
457: INTO v_lcm_enabled_flag
458: FROM MTL_PARAMETERS
459: WHERE ORGANIZATION_ID = p_ship_to_org_id;
460:
461: IF v_lcm_enabled_flag = 'N' THEN
462: RETURN v_lcm_enabled_flag;

Line 630: FROM mtl_parameters

626: WHERE id_flex_code = 'MTLL';
627:
628: SELECT project_reference_enabled
629: INTO v_proj_ref_enabled
630: FROM mtl_parameters
631: WHERE organization_id = x_org_id;
632:
633: v_delim := fnd_flex_ext.get_delimiter('INV', v_flex_code, v_flex_num);
634: str1 := '||''' || v_delim || '''||';

Line 772: FROM MTL_PARAMETERS mp

768: BEGIN
769: --Bug7037252/6349028/6343400. Added following SELECT
770: SELECT NVL(mp.wms_enabled_flag,'N')
771: INTO l_wms_enabled_flag
772: FROM MTL_PARAMETERS mp
773: WHERE mp.organization_id=v_org_id ;
774: SELECT NVL(ccicv.item_cost, 0)
775: INTO v_item_cost
776: FROM cst_cg_item_costs_view ccicv, mtl_parameters mp

Line 776: FROM cst_cg_item_costs_view ccicv, mtl_parameters mp

772: FROM MTL_PARAMETERS mp
773: WHERE mp.organization_id=v_org_id ;
774: SELECT NVL(ccicv.item_cost, 0)
775: INTO v_item_cost
776: FROM cst_cg_item_costs_view ccicv, mtl_parameters mp
777: WHERE v_locator_id IS NULL
778: AND ccicv.organization_id = v_org_id
779: AND ccicv.inventory_item_id = v_item_id
780: AND ccicv.organization_id = mp.organization_id

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

780: AND ccicv.organization_id = mp.organization_id
781: AND ccicv.cost_group_id = DECODE(mp.primary_cost_method, 1, 1, NVL(mp.default_cost_group_id, 1))
782: UNION ALL
783: SELECT NVL(ccicv.item_cost, 0)
784: FROM mtl_item_locations mil, cst_cg_item_costs_view ccicv, mtl_parameters mp
785: WHERE v_locator_id IS NOT NULL
786: AND mil.organization_id = v_org_id
787: AND mil.inventory_location_id = v_locator_id
788: AND mil.project_id IS NULL

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

791: AND ccicv.organization_id = mp.organization_id
792: 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)))
793: UNION ALL
794: SELECT NVL(ccicv.item_cost, 0)
795: FROM mtl_item_locations mil, mrp_project_parameters mrp, cst_cg_item_costs_view ccicv, mtl_parameters mp
796: WHERE v_locator_id IS NOT NULL
797: AND mil.organization_id = v_org_id
798: AND mil.inventory_location_id = v_locator_id
799: AND mil.project_id IS NOT NULL