APPS.MTL_CCEOI_PROCESS_PVT dependencies on MTL_PARAMETERS

Line 52: mtl_parameters mp

48: BEGIN
49: SELECT NVL ( ccicv.item_cost, 0 )
50: INTO x_item_cost
51: FROM cst_cg_item_costs_view ccicv,
52: mtl_parameters mp
53: WHERE l_locator_id IS NULL
54: AND ccicv.organization_id = p_organization_id
55: AND ccicv.inventory_item_id = p_inventory_item_id
56: AND ccicv.organization_id = mp.organization_id

Line 66: mtl_parameters mp

62: UNION ALL
63: SELECT NVL ( ccicv.item_cost, 0 )
64: FROM mtl_item_locations mil,
65: cst_cg_item_costs_view ccicv,
66: mtl_parameters mp
67: WHERE l_locator_id IS NOT NULL
68: AND mil.organization_id = p_organization_id
69: AND mil.inventory_location_id = l_locator_id
70: AND mil.project_id IS NULL

Line 84: mtl_parameters mp

80: SELECT NVL ( ccicv.item_cost, 0 )
81: FROM mtl_item_locations mil,
82: mrp_project_parameters mrp,
83: cst_cg_item_costs_view ccicv,
84: mtl_parameters mp
85: WHERE l_locator_id IS NOT NULL
86: AND mil.organization_id = p_organization_id
87: AND mil.inventory_location_id = l_locator_id
88: AND mil.project_id IS NOT NULL

Line 6124: FROM MTL_PARAMETERS

6120: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6121: BEGIN
6122: SELECT SERIAL_NUMBER_TYPE
6123: INTO l_serial_number_type
6124: FROM MTL_PARAMETERS
6125: WHERE organization_id = MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID;
6126:
6127: mtl_serial_check.inv_qtybetwn(
6128: p_api_version => 0.9,

Line 6221: FROM MTL_PARAMETERS

6217: else
6218: if(v_org_id IS NOT NULL) then
6219: SELECT SERIAL_NUMBER_TYPE
6220: INTO v_serial_number_type
6221: FROM MTL_PARAMETERS
6222: WHERE ORGANIZATION_ID = v_org_id;
6223: end if;
6224: u1 := v_serial_number ;
6225: u2 := v_serial_number ;